NTSB investigations, 1980, OH
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1980
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") = 1980 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 CHI81IA015Incident · No injuriesClosedCessna 210M · Toledo, OHNTSB CHI81FEK09Accident · No injuriesClosedPiper PA32RT · Columbus, OHNTSB CHI81FEG04Accident · No injuriesClosedCessna 337P · Miamisburg, OHNTSB CHI81FEK07Accident · 1 fatalClosedSorrel SNS-2 · Columbus Grove, OHNTSB CHI81FEI08Accident · No injuriesClosedCessna 182 · Ravenna, OHNTSB CHI81FEK08Accident · No injuriesClosedRaven RX-7 · Dublin, OHNTSB CHI81FEK11Accident · No injuriesClosedCessna 414A · Paulding, OHNTSB CHI81FEG03Accident · Minor injuriesClosedMitsubishi MU-2B · Cambellstown, OHNTSB CHI81FEK06Accident · Minor injuriesClosedAeronca 7AC · Hilliard, OHNTSB CHI81FEG02Accident · No injuriesClosedCessna 172 · Springfield, OHNTSB CHI81FEK05Accident · No injuriesClosedCessna 152 · Cambridge, OHNTSB CHI81FEI07Accident · Serious injuriesClosedPiper PA-38 · Strongsville, OHNTSB CHI81FEI06Accident · Serious injuriesClosedCessna 152 · Youngstown, OHNTSB CHI81FEK03Accident · No injuriesClosedCessna 152 · Lima, OHNTSB CHI81FEI04Accident · No injuriesClosedCessna T310R · Ravenna, OHNTSB CHI81FEK04Accident · No injuriesClosedCessna 172N · Circleville, OHNTSB CHI81FEI05Accident · No injuriesClosedCessna 152 · Port Clinton, OHNTSB CHI81FEK02Accident · No injuriesClosedCessna 140 · Sunbury, OHNTSB CHI80FEI02Accident · No injuriesClosedRobinson R-22 · Marlboro, OHNTSB CHI81FEI01Accident · Minor injuriesClosedPiper PA-28 · Elyria, OHNTSB CHI81DEG01Accident · No injuriesClosedTaylorcraft BC12D · Cincinnati, OHNTSB CHI81FEI03Accident · No injuriesClosedCessna 150 · N Philadelphia, OHNTSB CHI81FEK01Accident · No injuriesClosedCessna 182 · Columbus, OHNTSB CHI80FEG25Accident · No injuriesClosedBellanca 8KCAB · Miamisburg, OHNTSB CHI80FEG24Accident · Minor injuriesClosedPiper PA-28 · Xenia, OHNTSB CHI81FEK27Accident · No injuriesClosedSchleicher K7 · Montpelier, OHNTSB CHI80FEI45Accident · Minor injuriesClosedCessna 172M · Strongsville, OHNTSB CHI80FEI44Accident · Minor injuriesClosedEL Tomcat MK-5A · Nevada, OHNTSB CHI80FEC39Accident · No injuriesClosedAero Comdr 690A · Toledo, OHNTSB CHI80FEI43Accident · 2 fatalClosedBreezy RLU-1 · Green Spgs, OHNTSB CHI80FEG23Accident · Serious injuriesClosedAdams LD-S · Blue Ash, OHNTSB CHI80FEI42Accident · No injuriesClosedPiper PA-24 · Sandusky, OHNTSB CHI80FEG22Accident · No injuriesClosedPiper PA-28 · Germantown, OHNTSB CHI80FEG21Accident · No injuriesClosedBeech C23 · Cincinnati, OHNTSB CHI80FEI41Accident · No injuriesClosedPiper PA-38 · Mansfield, OHNTSB CHI80FEK26Accident · No injuriesClosedCessna U206F · Rockford, OHNTSB CHI80FEI39Accident · Serious injuriesClosedAvian BLN Falcon · Wadsworth, OHNTSB CHI80FEI40Accident · No injuriesClosedCessna 310Q · Elyria, OHNTSB CHI80FEI37Accident · Serious injuriesClosedPiper PA-22 · Shelby, OHNTSB CHI80FEI38Accident · No injuriesClosedBell 47 · Norwalk, OHNTSB CHI80FA064Accident · 1 fatalClosedSchweizer I-26E · Chardon, OHNTSB CHI80FEI36Accident · 1 fatalClosedDehavilland DHC-1B · Salem, OHNTSB CHI80FEK24Accident · Minor injuriesClosedPiper PA-28 · Bellefonatine, OHNTSB CHI80FEK25Accident · No injuriesClosedSchweizer 2-33A · Marion, OHNTSB CHI80FEI34Accident · No injuriesClosedCessna 172 · Strongsville, OHNTSB CHI81FEI35Accident · Serious injuriesClosedSpeziosport DAL-1 · Tiffin, OHNTSB CHI80FEI33Accident · No injuriesClosedPiper PA-22 · Painesville, OHNTSB CHI80FEK23Accident · No injuriesClosedPiper PA-32 · Marietta, OHNTSB CHI80FEI31Accident · Minor injuriesClosedCessna 172H · Willoughby, OHNTSB CHI80FEI32Accident · Minor injuriesClosedQuickie 1 · Wadsworth, OH