NTSB investigations

267 cases where NTSB found Power plant.

Cases, newest first

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010571'))
  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.

NTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.Aug 24, 2008 · N3901R · Substantial damageNTSB NYC08FA242Accident · Minor injuriesField investigationFinal reportBeech V35B · Lancaster, PAA complete loss of engine power for undetermined reasons.Jul 8, 2008 · N9438Q · Substantial damageNTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.Jul 7, 2008 · N488SD · Substantial damageNTSB ANC08LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKA loss of engine power for an undetermined reason during an approach for landing, which resulted in a forced landing and collision with terrain.Jun 24, 2008 · N3236P · Substantial damageNTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.Jun 22, 2008 · N757HA · Substantial damageNTSB ANC08LA074Accident · No injuriesLimited investigationFinal reportLake L-4 · Girdwood, AKA partial loss of engine power for an undetermined reason, which resulted in a forced landing. Contributing to the accident was rough and uneven terrain.Jun 9, 2008 · N13RZ · Substantial damageNTSB NYC08CA208Accident · Minor injuriesData collectionFinal reportCessna 177RG · Bessemer, ALFailure of the left magneto for undetermined reasons resulting in a partial loss of engine power during takeoff.Jun 8, 2008 · N45133 · Substantial damageNTSB LAX08LA145Accident · No injuriesLimited investigationFinal reportBabcock KR-2 · Olympia, WAA total loss of engine power during takeoff due to the carburetor's mixture needle backing out.May 19, 2008 · N4276Y · Substantial damageNTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.May 10, 2008 · N893FE · Substantial damageNTSB CHI08LA125Accident · Serious injuriesLimited investigationFinal reportRans S-12 XL · Pelion, SCA loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.May 4, 2008 · N9148Y · Substantial damageNTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.Apr 11, 2008 · N9022N · Substantial damageNTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.Mar 20, 2008 · N3304W · Substantial damageNTSB SEA08LA087Accident · No injuriesLimited investigationFinal reportMaule M-4 · Bishop, CAA loss of engine power due to foreign object ingestion in the induction system, which resulted in a stuck/jammed exhaust valve during the takeoff.Mar 7, 2008 · N51430 · Substantial damageNTSB SEA08LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot's delay in initiating the go-around, and the flight instructor's inadequate supervision of the flight and delayed remedial action. Contributing to the accident were the momentary failure of the engine to respond, the failure of both the…Mar 3, 2008 · N8400A · Substantial damageNTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.Mar 3, 2008 · N234MT · Substantial damageNTSB SEA08LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Mukilteo, WALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was a power line.Feb 2, 2008 · N8794V · Substantial damageNTSB CHI08LA071Accident · No injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Detroit, MIThe separation of the engine cowling which resulted from maintenance personnel failing to follow maintenance procedures in that they did not latch the engine cowling following the maintenance inspection. A factor associated with the accident was their…Jan 9, 2008 · N349NB · Substantial damage