NTSB investigations, 1993, LA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1993
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") = 1993 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 FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.NTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.NTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).NTSB FTW93FA245Accident · 1 fatalField investigationFinal reportAir Tractor AT-402 · La Barre, LALoss of control for undetermined reasons.NTSB FTW93LA243Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Lafayette, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.NTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.NTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.NTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.NTSB FTW93FA192Accident · Minor injuriesField investigationFinal reportBell 206L-3 · West Monroe, LAThe pilot's inadequate planning and preparation prior to takeoff, and his failure to maintain obstacle clearance. Factors were the fog and low ceilingNTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.NTSB FTW93LA177Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Crowley, LASevere propeller and airframe vibration for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutNTSB FTW93FA163Accident · No injuriesField investigationFinal reportMBB BK 117 A-4 · Lafayette, LACyclic control rod movement was restricted due to improper installation of the lateral cyclic control rod by company maintenance personnel.NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barNTSB FTW93LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, LAThe loss of engine power due to a sheared accessory drive pin. A factor was the unsuitable terrainNTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrainNTSB FTW93LA151Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ville Platte, LAThe pilot's failure to maintain ground clearanceNTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB FTW93IA125Incident · No injuriesIncident investigationFinal reportBoeing 747-269BC · Alexandria, LAThe inflight delamination of the wing panel skin. Factors were the water contamination of the honeycomb panel.NTSB FTW93LA121Accident · No injuriesLimited investigationFinal reportCessna 150J · Waterproof, LAThe pilot's misjudged landing point and the excessive airspeed. A factor was the wet grass stripNTSB FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundNTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainNTSB FTW93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ruston, LAFailure at a hydraulic fitting, which resulted in a hydraulic leak, loss of hydraulic fluid, and subsequent loss of braking action during the landing roll.NTSB FTW93FA072Accident · 3 fatalField investigationFinal reportBeech V35B · Dixie Inn, LAThe pilot's failure to maintain control for undetermined reasons.