NTSB investigations, GA

6 cases where NTSB found Object/animal/substance, general.

Cases per year

20092026
NTSB investigations, GA per year, 2009–2026: 6 cases
20092
20141
20163

Latest 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\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022000'))
  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 ERA17CA047Accident · No injuriesData collectionFinal reportHawker Beechcraft G58 · Atlanta, GAThe pilot’s failure to maintain the proper airspeed during final approach and his subsequent loss of directional control during landing, which resulted in a runway excursion.Nov 1, 2016 · N525 · Substantial damageNTSB GAA16CA254Accident · No injuriesData collectionFinal reportBeech A36 · Griffin, GAThe pilot's decision to land with a tailwind, resulting in a runway overrun and collision with a highway road embankment.May 22, 2016 · N36SR · Substantial damageNTSB ERA16LA172Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Tyrone, GAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.Apr 30, 2016 · N7620B · Substantial damageNTSB ERA15LA052Accident · Serious injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Williamson, GAThe pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.Nov 15, 2014 · N28681 · DestroyedNTSB ERA09CA216Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe failure of the pilot to maintain clearance with a parked airplane.Mar 18, 2009 · N748CD · Substantial damageNTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.Jan 31, 2009 · N620KJ · Substantial damage