NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 DFW08FA053Accident · 1 fatalField investigationFinal reportBell 206L1 · Venice, LAThe pilot’s decision to continue to the destination landing platform in weather conditions below the company’s weather minimums and his failure to maintain aircraft control during the approach. Contributing to the passenger fatality and the severity of the…NTSB DEN08FA036Accident · 1 fatalField investigationFinal reportCessna 182Q · Farmerville, LAThe pilot's failure to maintain aircraft control due to the effects of impairment from alcohol consumption resulting in the collision with the trees.. A contributing factor was the Federal Aviation Administration's failure to identify existing evidence of…NTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.NTSB DFW08CA009Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Columbia, LAThe pilot's selection of an unsuitable landing area. Contributing factors were the tall vegetation on the sides of the airstrip and the short and confined landing area.NTSB DFW07CA201Accident · Serious injuriesData collectionFinal reportUltra Magic M-56C · Bossier City, LAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing.NTSB DFW07FA198Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Hosston, LAThe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB DFW07CA185Accident · No injuriesData collectionFinal reportBell 206 · Houma, LAThe pilot's failure to properly secure all loose items prior to takeoff.NTSB DFW07LA152Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Delhi, LAthe pilot's failure to maintain control of the airplane while practicing aerial application turns over a field.NTSB DFW07CA146Accident · No injuriesData collectionFinal reportSchweizer 269C · Slidell, LAThe pilot's encounter with settling with power condition while hovering out of ground effect. A contributing factor was the prevailing tailwind.NTSB DFW07CA142Accident · No injuriesData collectionFinal reportCessna 206 · Baton Rouge, LAFuel starvation as result of the pilot's failure to properly position the fuel selector. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Oak Grove, LAA complete loss of power due to failure of the impeller drive gear train and displacement of the blower spring drive mechanism, which resulted in seizure of the propeller shaft/crankshaft. Also causal was the failure of the phenolic separator bracket of the…NTSB DFW07CA127Accident · Minor injuriesData collectionFinal reportCessna 182L · Cheneyville, LAThe loss of engine power while climbing due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the soft terrain at the forced landing site.NTSB DFW07LA120Accident · 1 fatalLimited investigationFinal reportCessna U206G · Leeville, LAThe failure of the operator of the powerboat to maintain separation from the departing floatplane.NTSB DFW07LA116Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Morgan City, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA107Accident · No injuriesLimited investigationFinal reportCessna 210 · Sulphur, LAThe collapsed of the right main landing gear for undetermined reasons.