NTSB investigations, 1980, FL
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 | 7 |
|---|---|
| 1963 | 6 |
| 1964 | 199 |
| 1965 | 231 |
| 1966 | 227 |
| 1967 | 258 |
| 1968 | 206 |
| 1969 | 197 |
| 1970 | 214 |
| 1971 | 205 |
| 1972 | 234 |
| 1973 | 254 |
| 1974 | 238 |
| 1975 | 218 |
| 1976 | 203 |
| 1977 | 220 |
| 1978 | 250 |
| 1979 | 242 |
| 1980 | 261 |
| 1981 | 208 |
| 1982 | 190 |
| 1983 | 219 |
| 1984 | 230 |
| 1985 | 212 |
| 1986 | 217 |
| 1987 | 200 |
| 1988 | 187 |
| 1989 | 183 |
| 1990 | 147 |
| 1991 | 158 |
| 1992 | 131 |
| 1993 | 147 |
| 1994 | 175 |
| 1995 | 136 |
| 1996 | 137 |
| 1997 | 146 |
| 1998 | 162 |
| 1999 | 143 |
| 2000 | 138 |
| 2001 | 120 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 120 |
| 2005 | 150 |
| 2006 | 133 |
| 2007 | 150 |
| 2008 | 133 |
| 2009 | 103 |
| 2010 | 103 |
| 2011 | 110 |
| 2012 | 101 |
| 2013 | 91 |
| 2014 | 101 |
| 2015 | 99 |
| 2016 | 96 |
| 2017 | 97 |
| 2018 | 120 |
| 2019 | 113 |
| 2020 | 92 |
| 2021 | 97 |
| 2022 | 82 |
| 2023 | 83 |
| 2024 | 103 |
| 2025 | 105 |
| 2026 | 82 |
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\" = 'FL' 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" = 'FL' 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 MIA81FLD21Accident · No injuriesClosedCessna 172N · Cedar Key, FLNTSB MIA81FKT19Accident · No injuriesClosedPiper PA-24 · W.Palm Beach, FLNTSB MIA81FA031Accident · 2 fatalClosedPiper PA-18A · Lake Wales, FLNTSB MIA81FLD10Accident · No injuriesClosedCessna 182 · Reddick, FLNTSB MIA81FA032Accident · 2 fatalClosedPiper PA-28 · Cross City, FLNTSB MIA81DKT14Accident · No injuriesClosedPiper PA-28R · Everglades Cty, FLNTSB MIA81FA029Accident · 2 fatalClosedCessna 172N · Venice, FLNTSB MIA81FA028Accident · Serious injuriesClosedDouglas DC3A · Miami, FLNTSB MIA81FA027Accident · 2 fatalClosedErco 415-C · Lakeland, FLNTSB MIA81DKT13Accident · No injuriesClosedCessna 206 · Miami, FLNTSB MIA81FLD20Accident · No injuriesClosedCessna 337 · Cape Coral, FLNTSB MIA81FLA09Accident · No injuriesClosedPiper PA-38 · Ormond Beach, FLNTSB MIA81FLD19Accident · Minor injuriesClosedPiper PA-28 · Tampa, FLNTSB MIA81FLA11Accident · No injuriesClosedAerostar 601P · Gainesville, FLNTSB MIA81FA025Accident · 1 fatalClosedPiper PA-31 · Tamarac, FLNTSB MIA81FA024Accident · 2 fatalClosedPiper PA-23 · Fort Myers, FLNTSB MIA81FKT15Accident · No injuriesClosedCessna 172N · Miami, FLNTSB MIA81FLA08Accident · Minor injuriesClosedJaguar NSBP-1 · St Augustine, FLNTSB MIA81FLA07Accident · No injuriesClosedLuscombe 8A · Macclenny, FLNTSB MIA81DLD12Accident · No injuriesClosedCessna 210 · Stuart, FLNTSB MIA81FLD18Accident · 1 fatalClosedKnight Twst 01 · Winter Haven, FLNTSB MIA81FLD17Accident · Serious injuriesClosedCessna 182A · Orlando, FLNTSB MIA81DLA06Accident · No injuriesClosedMooney M20C · Bunnell, FLNTSB MIA81DLD16Accident · No injuriesClosedBeech C23 · St.Petersburg, FLNTSB MIA81DLD15Accident · No injuriesClosedPiper PA-23 · Cassia, FLNTSB MIA81DLD14Accident · No injuriesClosedCessna 182Q · Winter Haven, FLNTSB MIA81FA021Accident · 3 fatalClosedCessna 182 · Oak Hill, FLNTSB MIA81DLD13Accident · No injuriesClosedCessna 152 · Titusville, FLNTSB MIA81DLA05Accident · No injuriesClosedCessna 152 · Gainsville, FLNTSB MIA81FLA04Accident · No injuriesClosedRobertson T210M · Gainesville, FLNTSB MIA81FA019Accident · 2 fatalClosedPiper PA-23 · Jacksonville, FLNTSB MIA81DKT21Accident · No injuriesClosedMurray Air MA-1 · Palmdale, FLNTSB MIA81DLD11Accident · No injuriesClosedCessna 177 · Plant City, FLNTSB MIA81DKT11Accident · No injuriesClosedCessna 210 · Key Largo, FLNTSB MIA81DKJ04Accident · No injuriesClosedMustang II · Pensacola, FLNTSB MIA81FKT07Accident · No injuriesClosedCessna 205 · Belle Glade, FLNTSB MIA81IA017Incident · Minor injuriesClosedCessna 402A · Marathon, FLNTSB MIA81DKT10Accident · No injuriesClosedAero Comdr 560F · Naples, FLNTSB MIA81IA015Incident · No injuriesClosedDehavilland DH-114 · Immokalee, FLNTSB MIA81IA013Incident · No injuriesClosedDouglas DC-8 · Miami, FLNTSB MIA81FLD09Accident · Serious injuriesClosedCessna 401A · Fort Pierce, FLNTSB MIA81FLD08Accident · Minor injuriesClosedStinson 108-2 · Clearwater, FLNTSB MIA81FKJ03Accident · No injuriesClosedBell 47D1 · Panama City, FLNTSB MIA81DKT09Accident · Minor injuriesClosedPiper PA-31 · Naples, FLNTSB MIA81DKT05Accident · No injuriesClosedCessna 150 · West Palmbeach, FLNTSB MIA81FLD07Accident · 1 fatalClosedTern II · Ocoee, FLNTSB MIA81FA011Accident · 1 fatalClosedCessna 404 · Gowers Corner, FLNTSB MIA81FA010Accident · 3 fatalClosedPiper PA-28R · Jacksonville, FLNTSB MIA81FA009Accident · 2 fatalClosedCessna 152 · Cedar Key, FLNTSB MIA81FA008Accident · 3 fatalClosedBeech E18S · Gainesville, FL