NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.NTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.NTSB DFW07FA008Accident · 1 fatalField investigationFinal reportNorth American T-28C · Georgetown, LAThe pilot's failure to maintain control of the airplane which led to an aerodynamic stall. A contributing factor was the dark night.NTSB DFW07FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dry Prong, LAThe loss of engine power during cruise flight due to oil starvation, resulting in an emergency off-airport forced landing. A factor associated with the accident was the instructor's improper in-flight decision in delaying to seek an emergency landing site…NTSB DFW07IA018Incident · No injuriesIncident investigationFinal reportBell 206-L4 · Abbeville, LAA fire in the baggage area for undetermined reasons.NTSB DFW06FA193Accident · 2 fatalField investigationFinal reportMooney M20J · Newellton, LAThe pilot's continued flight into adverse weather conditions. Contributing factors were the prevailing thunderstorms, the dark night conditions, and Air Traffic Control's failure to issue hazardous weather information to the pilot.NTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.NTSB DFW06FA186Accident · 3 fatalField investigationFinal reportBeech BE58P · Jeanerette, LAThe pilot's continued flight into adverse weather condition and his delayed attempt to abort the landing. A contributing factor was the prevailing thunderstorm.NTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA124Accident · No injuriesData collectionFinal reportRobinson R-44 · West Monroe, LAThe pilot's loss of control while taxiing.NTSB DFW06LA118Accident · Minor injuriesLimited investigationFinal reportEurocopter EC120B · Intracoastal, LAThe pilot's loss of control for undetermined reasons.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA097Accident · Serious injuriesLimited investigationFinal reportRocket Flyers Turbine Legend · Hammond, LAThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA094Accident · No injuriesLimited investigationFinal reportAviation Specialties Unlimited Challenger II · Coushatta, LAThe loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.NTSB DFW06CA089Accident · No injuriesData collectionFinal reportAero Commander AC50 · Shreveport, LAThe pilot's failure to execute a missed approach after losing visual contact with the runway, which resulted in a collision with approach lights. Factors were the dark night conditions and the fog.NTSB DFW06FA083Accident · 2 fatalField investigationFinal reportBell 206L-1 · Patterson, LAThe improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…NTSB DFW06CA077Accident · No injuriesData collectionFinal reportCessna 182C · Gilliam, LAThe loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.NTSB DFW06CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.