NTSB investigations, 2009, LA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
NTSB investigations, 2009, LA per year, 1962–2026: 3,066 cases
19621
19633
1964120
1965109
1966108
1967118
1968100
1969100
197091
197175
197275
197388
197484
1975105
197693
1977106
1978108
1979103
1980110
198195
198278
198357
198472
198557
198647
198733
198836
198941
199040
199126
199225
199332
199425
199522
199640
199728
199827
199928
200026
200128
200226
200321
200427
200532
200618
200715
200813
200921
201016
201128
201223
201319
201419
201520
201621
201717
201818
201921
202023
202123
202216
202316
202426
202517
202610

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'
  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 CEN10CA086Accident · No injuriesData collectionFinal reportHoover Frank RV-8 · Houma, LAThe pilot's failure to maintain directional control during the landing roll.Dec 29, 2009 · N17325 · Substantial damageNTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.Dec 27, 2009 · N7230W · Substantial damageNTSB 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 CEN09FA603Accident · 1 fatalField investigationFinal reportCessna 182Q · Houma, LAThe pilot’s decision to take off into instrument meteorological conditions.Sep 24, 2009 · N96894 · DestroyedNTSB 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 CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.Aug 23, 2009 · N352JB · 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 CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…May 21, 2009 · N17214 · Substantial damageNTSB CEN09LA297Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Monroe, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.May 14, 2009 · N223SB · 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 CEN09CA283Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Iowa, LAA partial loss of engine power due to the Number 8 cylinder head cracking and separating from the barrel.May 7, 2009 · N8080K · DestroyedNTSB CEN09CA280Accident · No injuriesData collectionFinal reportCessna 152 · Opelousas, LAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel the airplane prior to flight.May 3, 2009 · N4590K · Substantial damageNTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.Apr 29, 2009 · N4603E · 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 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 CEN09LA198Accident · No injuriesLimited investigationFinal reportBell 206 · Galliano, LAThe failure of the tail rotor driveshaft and coupling during engine start due to the mechanic's failure to properly reattach the tail rotor driveshaft and coupling during maintenance.Mar 2, 2009 · N410RL · 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 damageNTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.Feb 1, 2009 · N3628T · Substantial damageNTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…Jan 4, 2009 · N748P · Destroyed