NTSB investigations

63 cases where NTSB found Aircraft oper/perf/capability, general.

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\", '010600'))
  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 CEN09CA496Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 240A · Albuquerque, NMA run-on landing of the balloon causing the basket to tip over, resulting in a passenger's injury.Aug 4, 2009 · N494LB · No damageNTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.Jul 31, 2009 · N337BA · Substantial damageNTSB ANC09LA072Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Jul 22, 2009 · N68088 · Substantial damageNTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.Jul 21, 2009 · N2027K · Substantial damageNTSB ANC09CA056Accident · No injuriesData collectionFinal reportMaule M-5-235C · Wasilla, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.Jun 12, 2009 · N407X · Substantial damageNTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.Apr 30, 2009 · N8034Y · Substantial damageNTSB ANC09CA028Accident · No injuriesData collectionFinal reportPiper PA-12 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area with an unfavorable wind.Apr 4, 2009 · N2997M · Substantial damageNTSB ANC09LA022Accident · No injuriesLimited investigationFinal reportDehavilland DHC-2 / U-6A · Kenai, AKThe flight instructor’s decision to attempt a touch-and-go landing toward rising terrain and with a tailwind, resulting in an in-flight collision with terrain during takeoff.Feb 20, 2009 · N5342G · Substantial damageNTSB DEN08CA161AccidentData collectionFinal reportQuicksilver MX II Sprint · Killeen, TXThe operator's failure to maintain clearance from objects during the landing roll. Contributing to the accident was the operator's decision to operate a vehicle for which he/she was not certified.Sep 22, 2008 · N9045Z · Substantial damageNTSB ANC08CA132Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing.Sep 2, 2008 · N285HC · Substantial damageNTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.Aug 9, 2008 · N777UN · 2 aircraft · Substantial damageNTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.Jun 8, 2008 · N416PH · DestroyedNTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.Jan 5, 2008 · N9896 · Substantial damage