NTSB investigations, 1999, 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
| 1962 | 1 |
|---|---|
| 1963 | 3 |
| 1964 | 120 |
| 1965 | 109 |
| 1966 | 108 |
| 1967 | 118 |
| 1968 | 100 |
| 1969 | 100 |
| 1970 | 91 |
| 1971 | 75 |
| 1972 | 75 |
| 1973 | 88 |
| 1974 | 84 |
| 1975 | 105 |
| 1976 | 93 |
| 1977 | 106 |
| 1978 | 108 |
| 1979 | 103 |
| 1980 | 110 |
| 1981 | 95 |
| 1982 | 78 |
| 1983 | 57 |
| 1984 | 72 |
| 1985 | 57 |
| 1986 | 47 |
| 1987 | 33 |
| 1988 | 36 |
| 1989 | 41 |
| 1990 | 40 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 32 |
| 1994 | 25 |
| 1995 | 22 |
| 1996 | 40 |
| 1997 | 28 |
| 1998 | 27 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 28 |
| 2002 | 26 |
| 2003 | 21 |
| 2004 | 27 |
| 2005 | 32 |
| 2006 | 18 |
| 2007 | 15 |
| 2008 | 13 |
| 2009 | 21 |
| 2010 | 16 |
| 2011 | 28 |
| 2012 | 23 |
| 2013 | 19 |
| 2014 | 19 |
| 2015 | 20 |
| 2016 | 21 |
| 2017 | 17 |
| 2018 | 18 |
| 2019 | 21 |
| 2020 | 23 |
| 2021 | 23 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 26 |
| 2025 | 17 |
| 2026 | 10 |
Where
Open the mapLatest 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\") = 1999
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.
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") = 1999 AND c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW00LA055Accident · No injuriesLimited investigationFinal reportCessna 172L · New Orleans, LAThe pilot's inadvertent starting of the engine. Factors were the pilot's failure to set the mixture control to the off position, and the intermittent short in the starter switch.NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.NTSB FTW00FA035Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · New Orleans, LAthe pilot's failure to maintain aircraft control which resulted in a stall/spin. A contributing factor was the dusk light condition.NTSB FTW00LA033Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lafayette, LAThe partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…NTSB FTW00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bogalusa, LAThe total loss of engine power as a result of water contamination in the fuel system.NTSB FTW00LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pineville, LAThe student pilot's misjudgment of distance/speed during approach resulting in his failure to attain the proper touchdown point.NTSB FTW00LA019Accident · No injuriesLimited investigationFinal reportCessna TU206A · Jeanerette, LAThe total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.NTSB FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.NTSB FTW99LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Jeanerette, LAThe pilot's failure to attain the proper touchdown point resulting in the aircraft overrunning the runway on landing roll. A factor was the gusty crosswind condition.NTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.NTSB FTW99LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAThe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA212Accident · 1 fatalField investigationFinal reportStanton Pitts S-1S · Coushatta, LAThe pilot's poor in-flight decision to perform aerobatics at a low altitude and slow airspeed, resulting in the inadvertent stall/spin.NTSB FTW99LA191Accident · No injuriesLimited investigationFinal reportBell OH-58A · Bastrop, LAThe failure of the refueling truck's filter to separate water resulting in the water contamination in the helicopter's fuel system and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA186Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Gheens, LAThe loss of engine power due to fuel starvation as result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA182Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAThe pilot's failure to maintain clearance with the crops being sprayed. A factor was the pilot's diverted attention.NTSB FTW99LA179Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Theriot, LAThe pilot's inadequate preflight inspection which led to a contaminated fuel supply and subsequent loss of engine power. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW99FA177Accident · 1 fatalField investigationFinal reportBeech V35 · Baton Rouge, LAThe pilot's performance of an abrupt maneuver immediately after takeoff, which resulted in an inadvertent stall.NTSB FTW99LA207Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Lafayette, LAThe pilot's inadvertent flight into an adverse weather condition. A factor was the turbulence.NTSB FTW99LA170Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Basile, LAThe separation of the right wing forward spar lower attachment fitting due to a fatigue fracture, which emanated from corrosion as a result of maintenance not being performed.NTSB FTW99LA159Accident · No injuriesLimited investigationFinal reportLuscombe 8E · New Iberia, LAThe pilot's inadvertent ground loop.NTSB FTW99LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe pilot's improper touchdown procedure, resulting in a main rotor blade contacting the tailboom. Factors were the soft and wet terrain conditions, and the loss of engine power due to the spiral fatigue failure of the gas generator turbine shafting due to…NTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.NTSB FTW99LA115Accident · Minor injuriesLimited investigationFinal reportDavis/Cleaver Renegade 2 · Port Allen, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA113Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Franklinton, LALoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.NTSB FTW99LA091Accident · No injuriesLimited investigationFinal reportCessna 172D · Homer, LAThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets. Factors were the low fuel level and the turbulence.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB FTW99LA081Accident · No injuriesLimited investigationFinal reportCessna 188 · Alexandria, LAThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in an inadvertent ground loop.