Fatal NTSB investigations, 2022

18 cases where the sequence of events included Collision during takeoff/land.

Cases per year

20082026
Fatal NTSB investigations, 2022 per year, 2008–2026: 168 cases
200810
20097
20106
20115
201210
20134
201410
20159
20167
20178
20187
20199
202014
202115
202218
20238
20247
20256
20268

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' 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 GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceDec 28, 2022 · N229GC · DestroyedNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaDec 26, 2022 · N600 · DestroyedNTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.Dec 5, 2022 · N99345 · DestroyedNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.Nov 25, 2022 · N361LX · Substantial damageNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorOct 18, 2022 · HC-CLR · DestroyedNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaOct 13, 2022 · HL1174 · Substantial damageNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaOct 6, 2022 · VH-PHP · DestroyedNTSB ERA22FA399Accident · 2 fatalClass 3 · FieldFinal reportConway Philip J Glasair Super II SFT · Bay City, WIThe continuation of a poorly-flown, unstabilized approach and the flight instructor’s failure to direct a discontinuance of that approach, resulting in a collision with terrain during turn to final.Sep 6, 2022 · N11HC · Substantial damageNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaAug 30, 2022 · V5-LMK · DestroyedNTSB ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.Aug 28, 2022 · N8741A · DestroyedNTSB CEN22FA383Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Hanna City, ILA total loss of engine power due to fuel exhaustion.Aug 13, 2022 · N30EV · Substantial damageNTSB CEN22FA299Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Mount Pleasant, TXThe pilot’s failure to maintain the proper glidepath while on final approach in night visual conditions, which resulted in a collision with trees.Jul 4, 2022 · N1403X · DestroyedNTSB GAA22WA197Accident · 1 fatalClass 3 · ForeignPiper PA31 · Deadman's Cay, BahamasJun 5, 2022 · N711JW · Substantial damageNTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…May 28, 2022 · N178LB · DestroyedNTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.May 15, 2022 · N17879 · Substantial damageNTSB GAA22WA162Accident · 1 fatalClass 5 · ForeignMooney M20K · Springbank, AB, CanadaApr 22, 2022 · C-GQMS · Substantial damageNTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…Apr 13, 2022 · N928JP · Substantial damage