NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 FTW96FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Thibodaux, LAfailure of the pilot to maintain clearance from the power line and utility pole. The gusty/crosswind (weather) condition was a related factor.NTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.NTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.NTSB FTW95LA327Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Monroe, LAThe pilot's improper positioning of the fuel selector resulting in fuel starvation and the failure of the pilot to follow the published emergency procedures for propeller feathering. Factors were the fence and the trees.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB FTW95LA289Accident · No injuriesLimited investigationFinal reportCessna 182 · Port Sulphur, LAThe pilot's misjudgement of his short field landing resulting in an intentional ground loop to avoid an overrun. Factors were the reduced braking effectiveness on the wet grass runway.NTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.NTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.NTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.NTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.NTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA165Accident · Minor injuriesLimited investigationFinal reportMaule MXT-7-180 · Eunice, LAThe pilot's failure to maintain clearance. A factor was the windshear condition.NTSB FTW95LA159Accident · Serious injuriesLimited investigationFinal reportRobinson S-12 Airaile · Sugartown, LAA partial loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.NTSB FTW95FA106Accident · 1 fatalField investigationFinal reportCessna 150 · Arnaudville, LAThe pilot's failure to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain (wooded river bank). A factor relating to the accident was: the pilot's use of a drug that was not…NTSB MIA95LA055Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Monroe, LAan in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.