Fatal NTSB investigations, 2009

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

Cases per year

20082026
Fatal NTSB investigations, 2009 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\") = 2009
    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 WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.Nov 15, 2009 · N17803 · Substantial damageNTSB CEN10LA034Accident · 2 fatalLimited investigationFinal reportPiper PA-18-135 · Sikeston, MOThe pilot's failure to maintain directional control during a crosswind takeoff.Oct 31, 2009 · N1198C · Substantial damageNTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.Jun 28, 2009 · N4396R · Substantial damageNTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.Jun 26, 2009 · N38171 · Substantial damageNTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.Jun 14, 2009 · N3226R · Substantial damageNTSB CEN09LA262Accident · 1 fatalLimited investigationFinal reportCapra, Salvatore O Aventura 2 · Des Allemands, LAThe pilot’s failure to achieve adequate altitude and airspeed before beginning a downwind turn after takeoff.Apr 22, 2009 · N912SC · Substantial damageNTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.Apr 17, 2009 · YV1181 · Substantial damage