NTSB investigations, 1998, 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\") = 1998
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") = 1998 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 FTW99FA049Accident · 2 fatalField investigationFinal reportCessna 150H · Marksville, LAThe pilot's failure to visually identify the hazardous condition of the runway. Factors were the dusk light condition and the pilot's failure to obtain NOTAMs.NTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.NTSB FTW99LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA32-300 · New Iberia, LAThe mechanic's failure to properly torque the connecting rod's bolt and nut during engine overhaul. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA031Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Bunkie, LAThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA030Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alexandria, LAThe pilot's failure to maintain clearance with the water during the turnaround maneuver. A factor was the haze over the river.NTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.NTSB FTW99LA014Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Farmerville, LAThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.NTSB FTW99FA004Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Newellton, LAThe pilot's failure to maintain aircraft control during an inadvertent entry into adverse weather conditions. A related factor was the fog.NTSB FTW99LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Venice, LAThe pilot's failure to maintain control of the airplane during high speed step-taxi. A factor was the swell left by the boat.NTSB FTW98LA347Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hayes, LAThe forced landing for undetermined reasons. A factor was no suitable terrain for the forced landing.NTSB FTW98FA338Accident · 3 fatalField investigationFinal reportCessna 210M · Leesville, LAThe pilot's failure to establish a climb during a night go-around. Factors were the lack of visual cues available to the pilot and the dark night illumination.NTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.NTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW98LA249Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Iowa, LApartial loss of engine power during takeoff for undetermined reason(s). The obstructions (trees & dirt bank) were related factors.NTSB FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.NTSB FTW98LA193Accident · Serious injuriesLimited investigationFinal reportLerille P & W 1937 · Lafayette, LAThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.NTSB FTW98FA185Accident · 2 fatalField investigationFinal reportYoung Glasair III · St. Martinville, LAThe pilot's failure to maintain control of the aircraft as a result of VFR flight into instrument meteorological conditions and flight into known adverse weather conditions. Contributing factors were turbulence, clouds, dark night and lack of an instrument…NTSB FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.NTSB FTW98LA161Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · St. Joseph, LAThe pilot's failure to maintain clearance from the trees. A factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.NTSB FTW98LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rayville, LAThe pilot's inadequate compensation for the gusting crosswinds. Factors were the gusting crosswinds and the pilot's lack of experience in gusting crosswinds.NTSB FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA131Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Lafayette, LAThe unsecured squat switch wires located in the nose gear that were crimped (damaged) when the landing gear was retracted and shorted, resulting in an in-flight fire. A factor was the failure of the landing gear to extend during the emergency descent/landing.NTSB FTW98LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Alexandria, LAThe fire in the normal braking system due to an undetermined reason.NTSB FTW98LA408Accident · No injuriesLimited investigationFinal reportPalermo Challenger II · Erwinville, LAThe pilot's failure to compensate for the prevailing crosswind. Factors were the crosswind and the loss of engine power due to the separation of the fuel pick-up line.