NTSB investigations, 1976, FL
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1976
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") = 1976 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 MIA77FLD24Accident · Minor injuriesClosedCessna 401 · Tampa, FLNTSB MIA77FLD23Accident · Minor injuriesClosedLet-Np-K L-13 · Clearwater, FLNTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLNTSB MIA77DLA22Accident · No injuriesClosedBeech 35 · Ft.Pierce, FLNTSB MIA77DLA12Accident · No injuriesClosedPiper PA-11 · Perry, FLNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FLNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLNTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLNTSB MIA77FLA11Accident · No injuriesClosedCessna 188B · St Augustine, FLNTSB DCA77AA007Accident · Serious injuriesClosedConvair 880 · Miami, FLNTSB MIA77FLD19Accident · No injuriesClosedPiper PA-32 · Lake Placid, FLNTSB MIA77DLD18Accident · Serious injuriesClosedBalloon FF-6 · Temple Terrace, FLNTSB MIA77DKT10Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLNTSB MIA77DKT11Accident · No injuriesClosedPiper PA-24 · Sanibel Island, FLNTSB MIA77FLA09Accident · No injuriesClosedCessna 177RG · Pensacola, FLNTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLNTSB MIA77DLD16Accident · No injuriesClosedPiper PA-28 · Rockledge, FLNTSB MIA77FLA08Accident · No injuriesClosedCessna 402 · Jacksonville, FLNTSB MIA77DA015Accident · 2 fatalClosedCessna 337G · Summer Haven, FLNTSB MIA77DLD14Accident · No injuriesClosedPiper PA-18 · Verobeach, FLNTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNTSB MIA77FA013Accident · 2 fatalClosedPiper PA-28R · Tallahassee, FLNTSB MIA77DKT09Accident · Minor injuriesClosedPiper PA-25 · Boynton Beach, FLNTSB MIA77DLA07Accident · No injuriesClosedCessna 210 · Jacksonville, FLNTSB MIA77FLD17Accident · No injuriesClosedBirdman TL-1 · Deland, FLNTSB MIA77FA010Accident · 3 fatalClosedPiper PA-31 · Tallahassee, FLNTSB MIA77DLA06Accident · No injuriesClosedPiper PA-24 · Lake City, FLNTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNTSB MIA77FA007Accident · Serious injuriesClosedFalcon Jet DA-20F · Naples, FLNTSB MIA77FLD13Accident · Serious injuriesClosedStinson 108-3 · Brandon, FLNTSB MIA77DKT07Accident · No injuriesClosedAero Comdr 600S2R · Homestead, FLNTSB MIA77FLD11Accident · No injuriesClosedCessna 150G · Riverview, FLNTSB MIA77DLD12Accident · No injuriesClosedPiper J-3 · Venice, FLNTSB MIA77DLD09Accident · No injuriesClosedGrum Amer AA-1B · Moss Bluff, FLNTSB MIA77DLD08Accident · No injuriesClosedBaby Ace D · Deland, FLNTSB MIA77DLD10Accident · No injuriesClosedSchweizer SGS126 · Oviedo, FLNTSB MIA76DLD07Accident · Minor injuriesClosedBowers NRI · Winter Haven, FLNTSB MIA77FKT05Accident · No injuriesClosedHiller UH-12D · Lake Worth, FLNTSB MIA77FLA05Accident · No injuriesClosedBeech B95 · Gainesville, FLNTSB MIA77FLD06Accident · Serious injuriesClosedNavion A · Geneva, FLNTSB MIA78DKT04Accident · Minor injuriesClosedBeech C35 · Key Largo, FLNTSB MIA77FA003Accident · No injuriesClosedBoeing 727 · Miami, FLNTSB MIA77FA002Accident · 2 fatalClosedCessna 150J · Kissimee, FLNTSB MIA77FLD05Accident · Minor injuriesClosedBeech 35 · Merritt Island, FLNTSB MIA77DLA04Accident · No injuriesClosedEnstrom F-28 · Destin, FLNTSB MIA77FLD04Accident · No injuriesClosedCessna 310 · Sarasota, FLNTSB MIA76DLD02Accident · No injuriesClosedEnstrom F-28A · Lake Placid, FLNTSB MIA77FLD03Accident · No injuriesClosedCessna 150L · Merritt Island, FLNTSB MIA77FLA01Accident · Serious injuriesClosedGrum Amer AA1-B · Lee, FL