NTSB investigations, 2017, LA

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 2017, 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\") = 2017
    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 GAA18CA066Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · New Orleans, LAThe pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.Nov 29, 2017 · N744WT · Substantial damageNTSB CEN18FA030Accident · 1 fatalField investigationFinal reportTemco GC 1B · Pineville, LAThe loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.Nov 10, 2017 · N2363B · Substantial damageNTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.Nov 7, 2017 · N138WH · No damageNTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.Aug 17, 2017 · N48TZ · Substantial damageNTSB CEN17FA281Accident · 1 fatalField investigationFinal reportCessna 150F · Farmerville, LAThe pilot's failure to maintain clearance from the lake during a low-level maneuver.Jul 23, 2017 · N8661S · Substantial damageNTSB GAA17CA389Accident · No injuriesData collectionFinal reportCessna 172 · Shreveport, LAThe student’s improper landing flare, which resulted in a hard landing.Jul 3, 2017 · N2173Z · Substantial damageNTSB CEN17LA229Accident · No injuriesLimited investigationFinal reportHughes 269C · Tallulah, LAThe pilot's failure to reset the cyclic trim before takeoff, which resulted in ground resonance.Jun 10, 2017 · N7482F · Substantial damageNTSB CEN17LA228Accident · Serious injuriesLimited investigationFinal reportThompson Angel Hawk II · Homer, LAA total loss of engine power due to the engine’s unresolved high operating temperatures, which resulted in failure of the distributor rotor and drive shaft, and the pilot’s failure to maintain airspeed during the subsequent forced landing, which resulted in…Jun 9, 2017 · N335JT · Substantial damageNTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.May 9, 2017 · N520ER · 2 aircraft · No damageNTSB CEN17LA174Accident · No injuriesLimited investigationFinal reportBell 407 · Venice, LAAn in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…May 2, 2017 · N457PH · Substantial damageNTSB CEN17FA169Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Collinston, LAThe failure of the flight instructor and the commercial pilot to maintain adequate clearance from a power line during an aerial application training flight.Apr 30, 2017 · N1899G · DestroyedNTSB CEN17LA166Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Covington, LAThe pilot's improper fuel planning, which resulted in a total loss of power to both engines due to fuel exhaustion.Apr 23, 2017 · N3548J · Substantial damageNTSB CEN17LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Vidrine, LAThe total loss of engine power for reasons that could not be determined because an examination of the engine and a test run did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Apr 21, 2017 · N653LA · Substantial damageNTSB CEN17LA157Accident · No injuriesLimited investigationFinal reportCessna 210 · Minden, LAThe pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.Apr 15, 2017 · N7358E · Substantial damageNTSB CEN17FA112Accident · 1 fatalField investigationFinal reportBell 407 · Chauvin, LAThe pilot's failure to maintain proper altitude resulting in a collision with water for reasons that could not be determined based on the available information.Feb 27, 2017 · N1371 · DestroyedNTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.Feb 15, 2017 · N598PB · Substantial damageNTSB CEN17LA092Accident · Minor injuriesLimited investigationFinal reportZenith CH750 Stol · Jennings, LAA failure of the right fuel tank to supply fuel to the engine for reasons that could not be determined, which resulted in a total loss of engine power due to fuel starvation.Jan 30, 2017 · N1972C · Substantial damage