NTSB investigations, 1981, FL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first
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\") = 1981
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") = 1981 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 MIA81DLA34Accident · Minor injuriesClosedPiper PA-22 · High Springs, FLNTSB MIA81FLD64Accident · Minor injuriesClosedBellanca 17-31 · Melbourne, FLNTSB MIA81DLD63Accident · Minor injuriesClosedAero Comdr 100 · Ft Pierce, FLNTSB MIA81FA112Accident · 1 fatalClosedPiper PA-22 · Sumatra, FLNTSB MIA81DLA33Accident · No injuriesClosedBeech 58P · Jacksonville, FLNTSB MIA81FKT93Accident · No injuriesClosedPiper PA-28 · Coral Springs, FLNTSB MIA81DLA38Accident · No injuriesClosedBeech 95B · Tallahassee, FLNTSB MIA81DLA32Accident · No injuriesClosedBede BD-4 · Tallahassee, FLNTSB MIA81DKT92Accident · No injuriesClosedBoeing E-75 · Opalocka, FLNTSB MIA81IA110Incident · No injuriesClosedBeech 3NM · Jacksonville, FLNTSB MIA81FKT81Accident · No injuriesClosedBeech D18S · Palm Beach, FLNTSB MIA81FA111Accident · No injuriesClosedBoeing 727 · Miami, FLNTSB MIA81DLD58Accident · No injuriesClosedPiper PA-28 · Long Boat Key, FLNTSB MIA81DKJ16Accident · No injuriesClosedPiper PA-24 · Panama City, FLNTSB MIA81FKT90Accident · No injuriesClosedPiper PA-31 · Ft.Lauderdale, FLNTSB MIA81FA107Accident · 2 fatalClosedPiper J5A · Carrabelle, FLNTSB MIA81DLD62Accident · Minor injuriesClosedPiper PA-22 · Captiva, FLNTSB MIA81DKJ15Accident · No injuriesClosedBellanca 8GCBC · Destin, FLNTSB MIA81AA106Accident · Minor injuriesClosedBoeing 727 · Ft.Lauderdale, FLNTSB MIA81FKT88Accident · Minor injuriesClosedLake LA-4 · Tavernier, FLNTSB MIA81FA104Accident · 2 fatalClosedBeech H18 · Ft.Lauderdale, FLNTSB MIA81IA103Incident · No injuriesClosedLockheed L-1011 · Ft.Lauderdale, FLNTSB MIA81DLD61Accident · No injuriesClosedCessna T188C · Romeo, FLNTSB MIA82FA025Accident · 2 fatalClosedPiper PA-23 · Bunnell, FLNTSB MIA81DLA31Accident · Serious injuriesClosedBellanca 8GCBC · Ormond Beach, FLNTSB MIA81DKT89Accident · No injuriesClosedPiper PA-31 · Homestead, FLNTSB MIA81DKT86Accident · No injuriesClosedCessna 150 · Key West, FLNTSB MIA81FLD60Accident · Serious injuriesClosedAeronca 7DC · Okeechobee, FLNTSB MIA81DKT85Accident · Minor injuriesClosedCessna 152 · Palm Beach, FLNTSB MIA81FLD57Accident · Serious injuriesClosedCessna 172N · Chuluota, FLNTSB MIA81FA102Accident · 2 fatalClosedBeech 65-B80 · Groveland, FLNTSB MIA81FA101Accident · No injuriesClosedCessna P206A · Marathon, FLNTSB MIA81DLD59Accident · No injuriesClosedBurkhart G-10Z · Haines, FLNTSB MIA81DA108Accident · No injuriesClosedMooney M20K · Defuniak Sprgs, FLNTSB MIA81DKJ13Accident · No injuriesClosedBeech C-24R · Crestview, FLNTSB MIA81FLD56Accident · No injuriesClosedBeech 56TC · Arcadia, FLNTSB MIA81FLD55Accident · No injuriesClosedCessna 182 · Tampa, FLNTSB MIA81FA096Accident · 3 fatalClosedBeech B95 · Titusville, FLNTSB MIA81FLD54Accident · Minor injuriesClosedCessna 172 · Sebastian Inlt, FLNTSB MIA81FA095Accident · 1 fatalClosedPiper PA-28 · Palm Bay, FLNTSB MIA81FLD53Accident · Serious injuriesClosedCessna 172 · Tampa, FLNTSB MIA81FA093Accident · 2 fatalClosedPiper PA-28 · Lakeland, FLNTSB MIA81FA094Accident · 3 fatalClosedPiper PA-32R · Naples, FLNTSB MIA81FKT84Accident · No injuriesClosedCessna 172 · Clewiston, FLNTSB MIA81FA091Accident · No injuriesClosedPiper PA-28R · Jacksonville, FLNTSB MIA81DLA30Accident · No injuriesClosedBellanca 7ECA · Ormond Beach, FLNTSB MIA81FLD51Accident · Minor injuriesClosedPiper PA-34 · Deer Park, FLNTSB MIA81DLD52Accident · No injuriesClosedCessna 182 · Brooksville, FLNTSB MIA81DKJ12Accident · No injuriesClosedCessna 172M · Marianna, FLNTSB MIA81FA090Accident · 1 fatalClosedMooney M20J · St.Petersburg, FL