NTSB investigations, 2009, LA

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

Cases per year

20082026
NTSB investigations, 2009, LA per year, 2008–2026: 136 cases
20085
20098
20105
201111
20129
201311
201410
20158
201611
20179
20187
20199
20204
20217
20224
20236
20248
20253
20261

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.\"eventStateOrRegion\" = 'LA' 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 CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.Oct 10, 2009 · N8642S · 2 aircraft · Substantial damageNTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.Sep 6, 2009 · N131EH · Substantial damageNTSB CEN09CA497Accident · Serious injuriesData collectionFinal reportunknown kit · Abbeville, LAA total loss of engine power for undetermined reasons.Aug 5, 2009 · UNK · Substantial damageNTSB CEN09CA510Accident · No injuriesData collectionFinal reportWohnoutka Steven M Team Z MAX · Iowa, LAA total loss of engine thrust during initial climb due to the failure of the airplane's propeller as a result of preexisting damage.Jul 4, 2009 · N301SS · Substantial damageNTSB CEN09LA299Accident · Serious injuriesLimited investigationFinal reportNorthwing Apache Sport · Franklinton, LAThe pilot's failure to maintain airspeed which resulted in a stall. Contributing to the accident was the pilot's lack of flight experience in the weight-shift trike.May 13, 2009 · N61740 · Substantial damageNTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.Apr 20, 2009 · N226BW · DestroyedNTSB CEN09LA225Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Ville Platte, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.Mar 22, 2009 · N5189P · Substantial damageNTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…Feb 28, 2009 · N91593 · Substantial damage