NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 MIA66F0398Accident · No injuriesClosedGlobe GC-1A · Orlando, FLNTSB MIA66F0393Accident · No injuriesClosedChampion 7FC · Kissimee, FLNTSB MIA66F0505Accident · Serious injuriesClosedNavion A · Oceanway, FLNTSB MIA66A0074Accident · No injuriesClosedBrantly B-2 · Tampa, FLNTSB MIA66F0377Accident · No injuriesClosedPiper PA-24 · Orlando, FLNTSB MIA66F0379Accident · No injuriesClosedPiper PA-24 · Orlando, FLNTSB MIA66F0357Accident · No injuriesClosedBeechcraft A35 · Miami, FLNTSB MIA66F0392Accident · Serious injuriesClosedBeech A23 · Pahokee, FLNTSB MIA66F0384Accident · No injuriesClosedCessna 310 · Miami, FLNTSB MIA66F0366Accident · Minor injuriesClosedBeech A35 · Lake Worth, FLNTSB MIA66D0341Accident · No injuriesClosedCessna 210 · Opa Locka, FLNTSB MIA66A0068Accident · No injuriesClosedN.American NA-265 · W Palm Beach, FLNTSB MIA66D0354Accident · Minor injuriesClosedPiper PA-22 · Clewiston, FLNTSB MIA66A0064Accident · No injuriesClosedBoeing B-727 · Tampa, FLNTSB MIA66A0063Accident · Minor injuriesClosedBell 47D1 · Homestead, FLNTSB MIA67F0065Accident · Minor injuriesClosedPiper PA-22 · Tallahassee, FLNTSB MIA66D0419Accident · 1 fatalClosedCessna 150 · Marathon, FLNTSB MIA66F0337Accident · Minor injuriesClosedLuscombe 8A · Orlando, FLNTSB MIA66D0352Accident · No injuriesClosedPiper PA-18 · Ft Lauderdale, FLNTSB MIA66A0060Accident · No injuriesClosedPiper PA-24 · Naples, FLNTSB MIA66F0340Accident · No injuriesClosedCessna 172E · Lake Wales, FLNTSB MIA66F0311Accident · No injuriesClosedBeechcraft G-35 · Orlando, FLNTSB MIA66F0338Accident · No injuriesClosedCessna 172 · Deland, FLNTSB MIA66F0307Accident · No injuriesClosedBeechcraft D-18S · Miami, FLNTSB MIA66A0051Accident · No injuriesClosedBrantly B-2 · Opa Locka, FLNTSB MIA66D0284Accident · No injuriesClosedCessna 150 · Miami, FLNTSB MIA66A0050Accident · 2 fatalClosedCessna 182 · Marthon-Key W, FLNTSB MIA66F0309Accident · No injuriesClosedCessna 172F · Homestead, FLNTSB MIA66A0047Accident · No injuriesClosedConvair 240D · Tallahassee, FLNTSB MIA66F0301Accident · Serious injuriesClosedStinson V-77 · Ormond Beach, FLNTSB MIA66F0303Accident · No injuriesClosedPiper J3-C · Lk Thonotosas, FLNTSB MIA66F0300Accident · No injuriesClosedBeechcraft K35 · Keystone Hts, FLNTSB MIA66F0331Accident · Minor injuriesClosedPiper PA-25 · Pahokee, FLNTSB MIA66D0275Accident · No injuriesClosedCessna 150 · Homestead, FLNTSB MIA66F0270Accident · No injuriesClosedCessna 150 · Daytona Beach, FLNTSB MIA66D0325Accident · No injuriesClosedPiper PA-12 · Gainesville, FLNTSB MIA66F0299Accident · No injuriesClosedStinson 108-1 · Plantation, FLNTSB MIA66D0375Accident · No injuriesClosedPiper PA-28 · Englewood, FLNTSB MIA66A0043Accident · No injuriesClosedHughes 269B · Jacksonville, FLNTSB MIA66D0293Accident · No injuriesClosedMooney M20C · Immokalee, FLNTSB MIA66D0283Accident · No injuriesClosedPiper PA-24 · Opa Locka, FLNTSB MIA66F0294Accident · No injuriesClosedPiper PA-22 · Holmes Beach, FLNTSB MIA66D0296Accident · No injuriesClosedCessna 310J · Belle Glade, FLNTSB MIA66F0287Accident · Minor injuriesClosedMooney M20E · Cedar Key, FLNTSB MIA66D0320Accident · No injuriesClosedLuscombe 8A · Chipley, FLNTSB MIA66D0292Accident · No injuriesClosedCessna 172 · Miami, FLNTSB MIA66D0277Accident · No injuriesClosedPiper PA-28 · Hollywood, FLNTSB MIA66A0037Accident · 2 fatalClosedPiper PA-30 · Port Orange, FLNTSB MIA66A0036Accident · No injuriesClosedHughes 269A · Merritt Isle, FLNTSB MIA66I0035Incident · No injuriesClosedBoeing B-727 · Tampa, FL