NTSB investigations, 2018, 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, 2018, 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\") = 2018
    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 GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.Oct 8, 2018 · N1500E · Substantial damageNTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.Oct 6, 2018 · N56949 · Substantial damageNTSB CEN18FA359Accident · 2 fatalField investigationFinal reportPiper PA28R · Kaplan, LAThe pilot's failure to maintain clearance from a charted and illuminated television/radio tower.Aug 31, 2018 · N7430J · DestroyedNTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.Aug 29, 2018 · N956X · Substantial damageNTSB CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.Aug 22, 2018 · N4275Q · Substantial damageNTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2018 · N254LA · Substantial damageNTSB CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.Jul 20, 2018 · N327BK · Substantial damageNTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jul 19, 2018 · N7080F · Substantial damageNTSB CEN18LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Springhill, LAThe pilot’s exceedance of the airplane's critical angle of attack during an improper go-around procedure which resulted in an aerodynamic stall.Jul 3, 2018 · N689KC · Substantial damageNTSB CEN18LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Baton Rouge, LAThe improper insulation of the anticollision light wiring, which resulted in the ignition of combustible fuel vapors in the outboard section of the right wing; the source of the fuel leak could not be determined due to fire damage.Jun 8, 2018 · N190RS · Substantial damageNTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.Jun 6, 2018 · N710JT · Substantial damageNTSB GAA18CA297Accident · Minor injuriesData collectionFinal reportPiper PA22 · Start, LAThe pilot’s improper landing flare, which resulted in a bounced landing.May 23, 2018 · N4913Z · Substantial damageNTSB CEN18FA182Accident · 1 fatalField investigationFinal reportMD Helicopter 369D · Luling, LAThe pilot's failure to maintain clearance from the powerline structure while hovering, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.May 20, 2018 · N362JS · DestroyedNTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.Apr 28, 2018 · N71261 · Substantial damageNTSB DCA18FA144Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC 9 83(MD-83) · Alexandria, LAthe failure of the right main landing gear under normal loads due to fatigue cracking in an area subject to an FAA Airworthiness Directive that was not adequately inspected.Apr 20, 2018 · N807WA · Substantial damageNTSB GAA18CA153Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Many, LAThe pilot’s improper application of the brakes during landing, which resulted in a nose-over.Mar 8, 2018 · N105BH · Substantial damageNTSB GAA18CA138Accident · No injuriesData collectionFinal reportSikorsky S76 · New Iberia, LAThe helicopter’s striking of a pothole while taxiing, which resulted in the right main landing gear collapsing.Feb 18, 2018 · N860AL · Substantial damageNTSB CEN18LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Patterson, LAThe pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion.Feb 6, 2018 · N9148B · Substantial damage