NTSB investigations, 1973, OH
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 1 |
| 1964 | 199 |
| 1965 | 184 |
| 1966 | 193 |
| 1967 | 189 |
| 1968 | 187 |
| 1969 | 129 |
| 1970 | 142 |
| 1971 | 147 |
| 1972 | 121 |
| 1973 | 124 |
| 1974 | 142 |
| 1975 | 101 |
| 1976 | 103 |
| 1977 | 112 |
| 1978 | 99 |
| 1979 | 115 |
| 1980 | 109 |
| 1981 | 81 |
| 1982 | 81 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 73 |
| 1986 | 59 |
| 1987 | 69 |
| 1988 | 59 |
| 1989 | 74 |
| 1990 | 52 |
| 1991 | 52 |
| 1992 | 56 |
| 1993 | 46 |
| 1994 | 52 |
| 1995 | 54 |
| 1996 | 44 |
| 1997 | 43 |
| 1998 | 29 |
| 1999 | 38 |
| 2000 | 46 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 46 |
| 2004 | 34 |
| 2005 | 37 |
| 2006 | 23 |
| 2007 | 41 |
| 2008 | 43 |
| 2009 | 32 |
| 2010 | 37 |
| 2011 | 43 |
| 2012 | 30 |
| 2013 | 22 |
| 2014 | 29 |
| 2015 | 17 |
| 2016 | 34 |
| 2017 | 33 |
| 2018 | 33 |
| 2019 | 27 |
| 2020 | 22 |
| 2021 | 27 |
| 2022 | 30 |
| 2023 | 19 |
| 2024 | 16 |
| 2025 | 23 |
| 2026 | 23 |
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\") = 1973
AND c.\"eventStateOrRegion\" = 'OH' 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") = 1973 AND c."eventStateOrRegion" = 'OH' 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 CHI74FEK12Accident · No injuriesClosedCessna 170B · Lima, OHNTSB CHI74FEK10Accident · No injuriesClosedCessna 150J · Vanwert, OHNTSB CHI74FEK18Accident · No injuriesClosedCessna 172M · Defiance, OHNTSB CHI74FEK09Accident · No injuriesClosedAero Comdr 500B · Findly, OHNTSB CHI74FEI17Accident · No injuriesClosedMooney M20B · Elyria, OHNTSB DCA74AZ012Accident · Serious injuriesClosedDouglas DC-9 · North Canton, OHNTSB CHI74AC044Accident · 3 fatalClosedPiper PA-23 · Sandusky, OHNTSB CHI74DEI14Accident · No injuriesClosedSchweizer 2-33A · Middlefield, OHNTSB CHI74AC040Accident · 2 fatalClosedNavion B · Columbus, OHNTSB CHI74FEK08Accident · Minor injuriesClosedPiper PA-32 · Warsaw, OHNTSB CHI74DEI15Accident · Minor injuriesClosedCessna 182 · Atwater, OHNTSB CHI74AC038Accident · 2 fatalClosedAerostar 601 · Raymond, OHNTSB CHI74DEI11Accident · No injuriesClosedPiper PA-22 · Norwalk, OHNTSB CHI74FEI16Accident · No injuriesClosedPiper PA-24 · Ashland, OHNTSB CHI74DEK07Accident · No injuriesClosedPiper PA-28 · Pandora, OHNTSB NYC74AN034Accident · 2 fatalClosedBeech 65-A80 · Cincinnati, OHNTSB CHI74DEG12Accident · Serious injuriesClosedBeech V35B · Vandalia, OHNTSB CHI74FEG11Accident · No injuriesClosedMooney M20 · Miamisburg, OHNTSB CHI74AC037Accident · 2 fatalClosedHughes 269B · Springfield, OHNTSB CHI74FEG10Accident · Minor injuriesClosedCessna A150K · Mcarthur, OHNTSB CHI74FEG09Accident · Serious injuriesClosedCessna 150 · Oxford, OHNTSB CHI74AC035Accident · 1 fatalClosedMooney M20A · Summitville, OHNTSB CHI74AC032Accident · 1 fatalClosedCessna 150F · Columbiana, OHNTSB CHI74FEK06Accident · Serious injuriesClosedCessna 172 · Caledonia, OHNTSB CHI74DEI21Accident · Minor injuriesClosedCessna 177 · Perrysville, OHNTSB CHI74FEG08Accident · No injuriesClosedBell 47-G5 · Washingtn Ch, OHNTSB CHI74FEK05Accident · No injuriesClosedCessna 150 · Newark, OHNTSB CHI74FEI10Accident · Serious injuriesClosedCorben ACE · Brookfield, OHNTSB CHI74AC022Accident · No injuriesClosedPiper PA-28 · New Carisle, OHNTSB CHI74FEI12Accident · Minor injuriesClosedPiper PA-28 · Gustavus, OHNTSB CHI74AC021Accident · 1 fatalClosedPiper J-3 · Marysville, OHNTSB CHI74FEG06Accident · No injuriesClosedHoward DGA-15 · Amelia, OHNTSB CHI74FEG07Accident · No injuriesClosedCessna 172 · Forest Park, OHNTSB CHI74AC017Accident · No injuriesClosedBeech E18S · Urbana, OHNTSB CHI74DEI13Accident · Serious injuriesClosedSchweizer 2-22 · Medina, OHNTSB CHI74FEI07Accident · Serious injuriesClosedAmer Avco AA1-B · Painsville, OHNTSB CHI74AC014Accident · No injuriesClosedPiper PA-28 · Batavia, OHNTSB CHI74DEI06Accident · No injuriesClosedCessna 150F · Strongsville, OHNTSB CHI74FEK04Accident · No injuriesClosedCessna 180D · Columbus, OHNTSB CHI74FEK03Accident · No injuriesClosedCessna 182N · Newark, OHNTSB CHI74FEI23Accident · Minor injuriesClosedCessna 172 · S Parkman, OHNTSB CHI74DEI22Accident · No injuriesClosedCessna 150 · Clyde, OHNTSB CHI74FEG05Accident · Serious injuriesClosedMooney M20E · Harrison, OHNTSB CHI74DEI08Accident · No injuriesClosedCessna 150 · Brunswick, OHNTSB CHI74DEG04Accident · No injuriesClosedPiper PA-32 · Vandalia, OHNTSB CHI74FEK02Accident · Serious injuriesClosedCessna 150L · Gallion, OHNTSB CHI74FEI05Accident · No injuriesClosedSwearingen SA26 · N.Phildelpha, OHNTSB CHI74FEI09Accident · Minor injuriesClosedBellanca 7GCBC · E.Liverpool, OHNTSB CHI74FEG03Accident · 1 fatalClosedBeech 95-C55 · Cincinnati, OHNTSB CHI74FEG02Accident · Minor injuriesClosedBoeing A75N1 · W.Carrollton, OH