NTSB investigations, 2022, AL

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

Cases per year

20082026
NTSB investigations, 2022, AL per year, 2008–2026: 161 cases
200813
20098
20106
20118
201213
20137
201415
201514
20163
20178
201811
201910
20208
20216
20227
20239
20245
20254
20266

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\" = 'AL' 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 ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.Dec 13, 2022 · N74586 · Substantial damageNTSB ERA23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Alabaster, ALFailure of the tailwheel locking mechanism, which resulted in a loss of control during landing and a runway excursion.Dec 10, 2022 · N5301G · Substantial damageNTSB ERA23LA028Accident · No injuriesClass 4 · LimitedFinal reportMcglaughlin Richard Sportsman GS2 · Pell City, ALThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.Oct 14, 2022 · N302BM · Substantial damageNTSB ERA23LA003Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny XLT · Oneonta, ALThe uncertificated pilot’s failure to maintain control of the powered parachute during takeoff.Sep 24, 2022 · N5065Q · Substantial damageNTSB ERA22FA343Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter AS350 · Andalusia, ALThe pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.Jul 29, 2022 · N124LN · Substantial damageNTSB ERA22LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Tuscaloosa, ALThe student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.Jul 15, 2022 · N3301J · Substantial damageNTSB ERA22LA284Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Scottsboro, ALThe pilot’s failure to maintain directional during an aborted landing, which resulted in a runway excursion and collision with two parked trailers.Jun 22, 2022 · N5653K · Substantial damage