NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 FTW98LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Gonzales, LAThe inadvertent stall resulting from the flight instructor's failure to maintain airspeed during his delayed recovery from the bounced landing. Factors were the student's failure to maintain the proper airspeed and the instructor's inadequate supervision…NTSB FTW98LA058Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Lecompte, LAa loose battery cover, due to improper installation by maintenance personnel, that became jammed with an elevator control rod and restricted the movement of the elevator control system, which subsequently led to an uncontrolled impact with a tree, shortly…NTSB FTW98LA039Accident · No injuriesLimited investigationFinal reportCessna 175 · Arnaudville, LAa cracked fuel line, which allowed air to enter the line and lead to fuel starvation and loss of engine power. A related factor was: the lack of suitable terrain for a forced landing.NTSB FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW98LA030Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Welsh, LAthe pilot's failure to maintain control of the helicopter, while maneuvering to avoid an obstruction. The abrupt maneuver was a related factor.NTSB FTW98LA002Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Iberia, LAimproper touchdown by the flight instructor. A related factor was: soft sod in the touchdown/landing area.NTSB FTW97IA365Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-83(MD-83) · New Orleans, LARunway overrun for undetermined reasons.NTSB FTW97LA356Accident · Serious injuriesLimited investigationFinal reportSikorsky S-76A · Patterson, LAfailure of the copilot to maintain a positive rate of climb after takeoff, which led to an inadvertent descent and collision with a crop of sugar cane and the ground. Factors relating to the accident were: darkness, fog, and the pilot-in-command's inadequate…NTSB FTW97LA354Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Houma, LAThe loss of aircraft control resulting from a bird strike that severed the cyclic flight control.NTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.NTSB FTW97LA335Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Marksville, LAThe pilot's inadvertent stall during a turn to reverse direction during an aerial application flight. A factor was the pilot's chronic fatigue as result of cumulative long workdays.NTSB FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…NTSB FTW97LA311Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Patterson, LAThe pilot's failure to maintain terrain clearance.NTSB FTW97IA305Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lafayette, LAThe failure of the AC generator due to the failure of the anti-drive end bearing.NTSB FTW97LA294Accident · No injuriesLimited investigationFinal reportBeech C24R · Pollock, LAThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel selector. Factors were the pilot's failure to use the checklist and the lack of suitable terrain for the forced landing.NTSB FTW97FA285Accident · 1 fatalField investigationFinal reportAyres S2R-T15 · Oakridge, LAThe pilot's failure to maintain clearance for undetermined reasons.NTSB FTW97LA270Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Amelia, LApartial loss of engine power due to frog(s) being ingested into the engine. Factors relating to the accident were: the lack of altitude and lack of suitable terrain for a forced landing.NTSB FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB FTW97LA252Accident · Serious injuriesLimited investigationFinal reportBell 206B · New Iberia, LAthe pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.NTSB FTW97LA309Accident · No injuriesLimited investigationFinal reportBeech F33A · Monroe, LAan electrical short, which burned a hole in a fuel line, and subsequent fire from the burning fuel.NTSB FTW97LA245Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Church Point, LAThe pilot's improperly performed short field takeoff procedures.NTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…NTSB FTW97LA196Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Welsh, LAThe pilot's failure to maintain clearance with a moving vehicle. Factors were: the lack of runway signs and a runway safety area, and the difficulty for the pilot and driver of the vehicle to visually detect each other due to high vegetation at the edge of…NTSB FTW97FA181Accident · 1 fatalField investigationFinal reportCessna 172RG · Intracoastal, LAthe pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.NTSB FTW97FA121Accident · 1 fatalField investigationFinal reportMBB BO-105S · Lena, LAThe pilot's continued VFR flight into instrument meteorological conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors were the pilot not following company procedures and directives, the low ceiling, and the dark night…NTSB FTW97LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thibodaux, LAThe failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…NTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.NTSB FTW97LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Baton Rouge, LAfuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.