NTSB investigations, GA

6 cases where NTSB found Qualification/certification.

Cases per year

20122026
NTSB investigations, GA per year, 2012–2026: 6 cases
20121
20151
20171
20221
20231
20241

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\", '02031010'))
  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 ERA25LA019Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Gainesville, GAThe pilot’s sudden incapacitation due to an in-flight cardiac arrest, which necessitated a landing by a non-pilot passenger and resulted in a hard landing and collapse of the nose landing gear.Oct 18, 2024 · N11519 · Substantial damageNTSB ERA23FA109Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Dawsonville, GAThe pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…Jan 13, 2023 · N4254T · DestroyedNTSB ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…Apr 21, 2022 · N84GR · DestroyedNTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…Jul 1, 2017 · N44HJ · DestroyedNTSB ERA15FA359Accident · 5 fatalField investigationFinal reportBoatright Waylon RV10 · Alma, GAThe noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…Sep 16, 2015 · N122WK · DestroyedNTSB ERA13CA009Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Cumming, GAThe operation of the powered parachute by a non-certificated pilot, and his failure to maintain directional control during the initial climb, which resulted in a collision with trees.Oct 4, 2012 · N580PG · Substantial damage