NTSB investigations, NV
14 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 3 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'NV' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.NTSB LAX02LA152Accident · No injuriesLimited investigationFinal reportCessna 182P · Boulder City, NVthe pilot's failure to lean the mixture properly resulting in a partial loss of power.NTSB LAX00LA215Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Carson City, NVa loss of engine power due to contamination of the fuel system resulting in partial blockage of the cylinder number 2 fuel injection nozzle. A factor in the accident was the high density altitude.NTSB LAX00LA001Accident · No injuriesLimited investigationFinal reportIsmari Canard C3A · Henderson, NVA partial loss of engine power for undetermined nonmechanical reasons. A contributing factor was the rough nature of the terrain used for the forced landing.NTSB LAX99LA156Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Yerington, NVThe partial loss of engine power due to the pilot's failure to properly lean the engine for the high density altitude takeoff.NTSB LAX99LA095Accident · No injuriesLimited investigationFinal reportBeech 95 · Henderson, NVa loss of power in one engine due to the student pilot inadvertently selecting the off position on one fuel selector valve while accomplishing the prelanding checklist. The instructor's inadequate supervision of the flight was also causal.NTSB LAX97LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-180 · Reno, NVThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush. Factors in the accident were: the pilot's lack of qualification in the aircraft; the FAA pilot certification system's failure to transfer the…NTSB LAX96LA168Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVthe partial loss of engine power and the pilot's misjudged flare during an autorotation landing in soft dirt with excessive forward speed. The power loss resulted from flight operations in an environment which debris contaminated the engine's nozzle port and…NTSB LAX94LA300Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Elko, NVa loss of engine power from fuel exhaustion due to the pilot's improper preflight and fuel consumption calculations while operating with known equipment malfunctions.NTSB LAX92LA409Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Minden, NVPilot's and mechanic's inadequate inspection of the aircraft and the pilot's poor inflight decision by not returning to the departure airport after experiencing the initial engine loss of power on takeoff. Contributing to this accident was fuel starvation due…NTSB LAX92LA016Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Reno, NVA partial loss of engine power for undetermined non-mechanical reasons.NTSB SEA88LA119Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Elko, NVPlt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of…NTSB SEA86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus Iiit · Hawthorne, NVAfter a 5 hour flight in the motorized glider during which the engine was utilized on several occasions the pilot returned to his destination. Upon arrival he executed a number of low passes over the runway for photographers. The pilot executed a fly by…NTSB LAX83FA400Accident · Minor injuriesField investigationFinal reportBell 206-B · Battle Mountain, NVThe helicopter lost power during takeoff,touched down on the left skid,bounced and rolled over. The flt had originated at 1315 at a local field and proceeded to pick up a passenger at another location. The acft had just landed, picked up the passenger and was…