NTSB investigations, 1981, OH
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 22 |
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\") = 1981
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") = 1981 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 CHI82FEK04Accident · Minor injuriesClosedCessna 172 · Norwich, OHNTSB CHI82FEK03Accident · No injuriesClosedPiper PA-28 · Columbus, OHNTSB CHI82FEI02Accident · No injuriesClosedCessna 150J · Willowick, OHNTSB CHI82FA011Accident · Serious injuriesClosedPiper PA-23 · Niles, OHNTSB CHI82FEK02Accident · No injuriesClosedCessna 210L · Columbus, OHNTSB CHI82FEI01Accident · No injuriesClosedBeech D18S · Concord, OHNTSB CHI82FEG01Accident · Serious injuriesClosedMonocoupe 113 · New Carlisle, OHNTSB CHI82FA005Accident · 1 fatalClosedBLN Works FF-7 · Delaware, OHNTSB CHI82FEK01Accident · No injuriesClosedCessna 152 · New Albany, OHNTSB CHI81FEK31Accident · No injuriesClosedBLN Works FF-7B · Johnstown, OHNTSB CHI81FEG17Accident · No injuriesClosedBeech B24R · Winchester, OHNTSB CHI81FEK30Accident · Minor injuriesClosedBellanca 17-30A · Newark, OHNTSB CHI81FEI31Accident · No injuriesClosedCessna 172N · Elyria, OHNTSB CHI81FEG16Accident · Minor injuriesClosedBellanca 7ECA · Cedarville, OHNTSB CHI81FEI30Accident · No injuriesClosedCessna TU206F · Rock Creek, OHNTSB CHI81FEI29Accident · No injuriesClosedPiper PA-25 · Kansas, OHNTSB CHI81FA100Accident · 1 fatalClosedSchweizer SGS232 · Waynesville, OHNTSB CHI81FEK29Accident · Serious injuriesClosedGlobe GC-1 · Mt Vernon, OHNTSB CHI81FA094Accident · 1 fatalClosedCessna 421C · Rutland, OHNTSB CHI81FEI28Accident · No injuriesClosedCessna 310R · Cleveland, OHNTSB CHI81FEI27Accident · 1 fatalClosedAmeagle Mnbt · Painesville, OHNTSB CHI81FEI26Accident · Minor injuriesClosedStinson 108-1 · Chardon, OHNTSB CHI81FA087Accident · No injuriesClosedCessna 210D · Zanesville, OHNTSB CHI81FEI21Accident · No injuriesClosedPiper PA-22 · North Canton, OHNTSB CHI81FEG15Accident · No injuriesClosedRobinson R22 · Cincinnati, OHNTSB CHI81FA084Accident · 1 fatalClosedPiper PA-28 · Millbury, OHNTSB CHI81FA083Accident · 2 fatalClosedMooney M20C · Plymouth, OHNTSB CHI81FEK28Accident · 1 fatalClosedMonerai S · Montpelier, OHNTSB CHI81FEK27Accident · No injuriesClosedPiper PA-38 · Columbus, OHNTSB CHI81FEK26Accident · Serious injuriesClosedHughes 269A · Newark, OHNTSB CHI81FA079Accident · 3 fatalClosedAero Comdr 100 · Columbia Stat, OHNTSB CHI81FA077Accident · 2 fatalClosedCessna 152 · E Liverpool, OHNTSB CHI81FEK24Accident · No injuriesClosedBeech B35 · Columbus, OHNTSB CHI81IA080Incident · No injuriesClosedCessna 152 · Springfield, OHNTSB CHI81FEK23Accident · No injuriesClosedVarga 2150A · Delaware, OHNTSB CHI81DEG14Accident · No injuriesClosedBellanca 7ECA · Harrison, OHNTSB CHI81FEI25Accident · No injuriesClosedCessna 150L · Wadsworth, OHNTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHNTSB CHI81FEI23Accident · Minor injuriesClosedLuscombe 8A · Northfield, OHNTSB CHI81FEK25Accident · Minor injuriesClosedBoeing B75N1 · Richwood, OHNTSB CHI81FEG13Accident · Serious injuriesClosedWaco YKS7 · Hamilton, OHNTSB CHI81FEK22Accident · No injuriesClosedPiper PA-28 · Columbus, OHNTSB CHI81FEI22Accident · Minor injuriesClosedCessna 172 · Swanton, OHNTSB CHI81FEK21Accident · No injuriesClosedPiper PA-30 · Newark, OHNTSB CHI81DEK20Accident · No injuriesClosedSchweizer 1-36 · Montpelier, OHNTSB CHI81FEK19Accident · No injuriesClosedHiller UH-12D · Junction City, OHNTSB CHI81IA065Incident · No injuriesClosedMitsubishi MU-2B · Middletown, OHNTSB CHI81FEG12Accident · No injuriesClosedCessna 177B · Cincinnati, OHNTSB CHI81IA088Accident · Serious injuriesClosedBoeing 727 · Columbus, OHNTSB CHI81FEI20Accident · Serious injuriesClosedCessna 172 · Akron, OH