NTSB investigations, 2022, GA

13 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2022, GA per year, 2008–2026: 311 cases
200826
200918
201022
201122
201226
201313
201421
201517
201627
201717
201818
201913
20206
202115
202213
202316
202413
20255
20263

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 year(c.\"eventDate\") = 2022
    AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.Dec 29, 2022 · N9026P · Substantial damageNTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…Dec 8, 2022 · N900AW · Substantial damageNTSB ERA23LA074Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Newnan, GAThe flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.Nov 22, 2022 · N407MD · Substantial damageNTSB ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.Nov 14, 2022 · N81PW · Substantial damageNTSB ERA23LA053Accident · Minor injuriesClass 4 · LimitedFinal reportSchmidt Randall M Bushby Mustang II · Statesboro, GAA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.Nov 2, 2022 · N30RK · Substantial damageNTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.Oct 4, 2022 · N7494Y · Substantial damageNTSB ERA22LA291Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Warm Springs, GAThe loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.Jun 26, 2022 · N14FC · Substantial damageNTSB ERA22LA265Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23 · Stockbridge, GAA total loss of right engine power during initial climb for reasons that could not be determined.Jun 11, 2022 · N3477P · Substantial damageNTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.May 11, 2022 · N8007P · DestroyedNTSB ERA22LA220Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Tybee Island, GAA loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.May 6, 2022 · N24LA · Substantial damageNTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlApr 25, 2022 · N7572T · Substantial damageNTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.Apr 7, 2022 · N623W · Substantial damageNTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.Mar 19, 2022 · N1410F · Substantial damage