NTSB investigations, 1964, FL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1964
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") = 1964 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 UNK65X1197Accident · No injuriesClosedBeechraft T34B · Jacksonville, FLNTSB UNK65X1190Accident · Serious injuriesClosedAero Comdr 520 · Miami Beach, FLNTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLNTSB UNK65X1162Accident · No injuriesClosedCessna 195 · Miami, FLNTSB UNK65X1135Accident · No injuriesClosedCessna 172 · Belle Glade, FLNTSB UNK65X1133Accident · No injuriesClosedPiper J3 · Pensacola, FLNTSB UNK65X1116Accident · No injuriesClosedBoeing A75L3 · Immokalee, FLNTSB UNK65X1103Accident · No injuriesClosedAero Cmdr 680E · Jacksonville, FLNTSB UNK65X1069Accident · No injuriesClosedCessna 172E · Miami, FLNTSB UNK65X1061Accident · No injuriesClosedPiper PA24 · Bunnell, FLNTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FLNTSB UNK65X0934Accident · Minor injuriesClosedChampion 7FC · Opa Locka, FLNTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLNTSB UNK65X0927Accident · Serious injuriesClosedSikorsky S52 · Brandon, FLNTSB MIA65A0061Accident · 1 fatalClosedBellanca 14-19 · Bronson, FLNTSB UNK65X0909Accident · No injuriesClosedCessna 170B · Parrish, FLNTSB UNK65X0898Accident · No injuriesClosedBeechcraft F35 · New Smyrna Bc, FLNTSB UNK65X0894Accident · No injuriesClosedCessna 310 · Ft Lauderdale, FLNTSB UNK65X0879Accident · No injuriesClosedBoeing A-75 · Homestead, FLNTSB UNK65X0872Accident · No injuriesClosedCessna 170B · Lantana, FLNTSB UNK65X0848Accident · No injuriesClosedCessna 140 · Vero Beach, FLNTSB UNK65X0817Accident · Minor injuriesClosedHughes 269A · Sebring, FLNTSB UNK65X0807Accident · 1 fatalClosedLuscombe 8A · Gainesville, FLNTSB UNK65X0803Accident · No injuriesClosedChampion 7FC · Kendall, FLNTSB UNK65X0789Accident · No injuriesClosedCessna 310G · Melbourne, FLNTSB UNK65X0733Accident · No injuriesClosedPiper PA24 · Lake City, FLNTSB UNK65X0705Accident · No injuriesClosedPiper PA28 · Tallahasse, FLNTSB UNK65X0675Accident · No injuriesClosedPiper PA30 · Melbourne, FLNTSB UNK65X0668Accident · No injuriesClosedPiper PA24 · Ft Lauderdale, FLNTSB UNK65X0650Accident · 2 fatalClosedPiper PA22 · Winter Haven, FLNTSB UNK65X0598Accident · No injuriesClosedCessna 150 · Terrytown, FLNTSB UNK65X0583Accident · Serious injuriesClosedCessna 206 · Destin, FLNTSB UNK65X0577Accident · Minor injuriesClosedCessna 140 · Palm Beach Gd, FLNTSB UNK65X0556Accident · No injuriesClosedChampion 7AC · Lantana, FLNTSB UNK65X0541Accident · Minor injuriesClosedCessna 170B · Candler, FLNTSB UNK65X0503Accident · No injuriesClosedBeechraft 35 · Kissimmee, FLNTSB MIA66F0297Accident · No injuriesClosedCessna 337 · Melbourne, FLNTSB UNK65X0476Accident · No injuriesClosedStinson 108 · Panama City, FLNTSB UNK65X0447Accident · Minor injuriesClosedCessna 180 · St George, FLNTSB UNK65X0412Accident · 2 fatalClosedCessna 150 · Crestview, FLNTSB UNK65X0385Accident · No injuriesClosedBeechcraft C185 · Miami, FLNTSB UNK65X0360Accident · No injuriesClosedBoeing B75N1 · Homestead, FLNTSB UNK65X0358Accident · Minor injuriesClosedBoeing A75 · Homestead, FLNTSB UNK65X0313Incident · No injuriesClosedBoeing 727 · Ft Lauderdale, FLNTSB UNK65X0261Accident · No injuriesClosedPiper PA24 · Pensacola, FLNTSB UNK65X0232Accident · Minor injuriesClosedCessna 182D · Okeechobee, FLNTSB UNK65X0230Accident · 6 fatalClosedCessna 210-5 · Plantation, FLNTSB UNK65X0217Accident · Minor injuriesClosedHelio 391B · Perry, FLNTSB UNK65X0197Accident · No injuriesClosedTaylorcraft BC12D · New Smyrna Bh, FLNTSB UNK65X0177Accident · No injuriesClosedCessna 172A · Orlando, FL