NTSB investigations, 2013, 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\") = 2013
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") = 2013 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 CEN14CA095Accident · No injuriesData collectionFinal reportCessna 182N · Paradis, LAThe collision with a bird which resulted in substantial damage to the airplane.NTSB CEN14LA081Accident · No injuriesLimited investigationFinal reportRockwell International 112 · Hammond, LAThe total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.NTSB CEN14CA082Accident · No injuriesData collectionFinal reportSikorsky S 76B · Port Fourchon, LAThe pilot's loss of control of the helicopter when it entered a settling with power condition during sudden gusty wind conditions on takeoff resulting in the helicopter subsequently impacting terrain.NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.NTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.NTSB CEN14LA048Accident · Minor injuriesLimited investigationFinal reportEurocopter Deutschland EC135P1 · Shreveport, LAThe mechanic's improper installation of the antitorque pedals, which resulted in an in-flight loss of helicopter control.NTSB CEN13LA472Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Simmesport, LAThe pilot's failure to maintain proper airplane pitch control while maneuvering at an altitude that was too low for recovery.NTSB CEN13FA420Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Oak Ridge, LAThe private pilot’s and the flight instructor’s failure to maintain airplane control while performing agricultural operations turns low to the ground, which resulted in a stall/spin. Contributing to the accident was the private pilot’s impairment due to his…NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB CEN13FA326Accident · 1 fatalField investigationFinal reportHawker Beechcraft B200GT · Baker, LAThe pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.NTSB CEN13LA321Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Abbeville, LAFailure of maintenance personnel to ensure adequate torque of a tailrotor drive shaft coupling bolt, which resulted in the partial disconnection of the drive shaft.NTSB CEN13CA282Accident · No injuriesData collectionFinal reportCessna 172RG · Abbeville, LAThe pilot's failure to properly secure the airplane before hand starting the engine and the failure of the brass tie down hook.NTSB CEN13LA249Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Covington, LAThe pilot’s failure to maintain airspeed during a banner towing operation, which resulted in the airplane stalling and landing hard.NTSB CEN13CA246Accident · No injuriesData collectionFinal reportCessna 172N · New Orleans, LAThe pilot's failure to perform a steep climb before going around following a low pass for a banner tow pickup.NTSB CEN13CA226Accident · No injuriesData collectionFinal reportEdward W Gray Lancair 360 · Alexandria, LAThe pilot's failure to attain the proper touchdown point, and his decision to continue the landing, which resulted in a runway excursion.NTSB CEN13LA225Accident · Minor injuriesLimited investigationFinal reportAtkins ACRO-SPORT I · Midland, LAThe failure of the left elevator torque tube due to poor quality welds by the manufacturer, which resulted in the loss of pitch control.NTSB CEN13FA192Accident · 3 fatalField investigationFinal reportSikorsky S-76A++ · Grand Lake, LAFracture of the red tail rotor blade spar, which resulted in the separation and departure of the red tail rotor blade from the helicopter and subsequent compromised tail gearbox. The red tail rotor blade was not recovered, thus the cause of the initial…NTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.