Fatal NTSB investigations, 2000, LA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 14 |
|---|---|
| 1965 | 8 |
| 1966 | 11 |
| 1967 | 18 |
| 1968 | 6 |
| 1969 | 14 |
| 1970 | 10 |
| 1971 | 11 |
| 1972 | 14 |
| 1973 | 15 |
| 1974 | 7 |
| 1975 | 13 |
| 1976 | 16 |
| 1977 | 17 |
| 1978 | 18 |
| 1979 | 17 |
| 1980 | 19 |
| 1981 | 15 |
| 1982 | 14 |
| 1983 | 12 |
| 1984 | 17 |
| 1985 | 12 |
| 1986 | 7 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 11 |
| 1990 | 9 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 4 |
| 1996 | 10 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 8 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 2 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 4 |
| 2025 | 5 |
| 2026 | 3 |
Where
Latest 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\") = 2000
AND c.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2000 AND c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 FTW01LA032Accident · 1 fatalLimited investigationFinal reportSmith Team Tango 2 · Dry Creek, LAthe pilot's VFR flight into IMC while in cruise, which resulted in his loss of control of the airplane due to spatial disorientation. Contributing factors were the clouds, and icing weather conditions, and the inadequate weather briefing.NTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB FTW00LA166Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pioneer, LAThe pilot's failure to maintain clearance with trees while maneuvering during an aerial application flight. A factor was the pilot's lack in experience with aerial application flight operations.