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.

NTSB MIA81DLA34Accident · Minor injuriesClosedPiper PA-22 · High Springs, FLSep 12, 1981 · N3258Z · Substantial damageNTSB MIA81FLD64Accident · Minor injuriesClosedBellanca 17-31 · Melbourne, FLSep 7, 1981 · N1004R · Substantial damageNTSB MIA81DLD63Accident · Minor injuriesClosedAero Comdr 100 · Ft Pierce, FLSep 7, 1981 · N3891X · Substantial damageNTSB MIA81FA112Accident · 1 fatalClosedPiper PA-22 · Sumatra, FLSep 6, 1981 · N893A · DestroyedNTSB MIA81DLA33Accident · No injuriesClosedBeech 58P · Jacksonville, FLSep 6, 1981 · N6678C · Substantial damageNTSB MIA81FKT93Accident · No injuriesClosedPiper PA-28 · Coral Springs, FLSep 3, 1981 · N2962S · Substantial damageNTSB MIA81DLA38Accident · No injuriesClosedBeech 95B · Tallahassee, FLSep 3, 1981 · N9978R · Substantial damageNTSB MIA81DLA32Accident · No injuriesClosedBede BD-4 · Tallahassee, FLSep 2, 1981 · N1034N · Substantial damageNTSB MIA81DKT92Accident · No injuriesClosedBoeing E-75 · Opalocka, FLSep 1, 1981 · N4808V · Substantial damageNTSB MIA81IA110Incident · No injuriesClosedBeech 3NM · Jacksonville, FLAug 31, 1981 · N9539 · Minor damageNTSB MIA81FKT81Accident · No injuriesClosedBeech D18S · Palm Beach, FLAug 27, 1981 · N25V · Substantial damageNTSB MIA81FA111Accident · No injuriesClosedBoeing 727 · Miami, FLAug 25, 1981 · 6Y-JMB · Substantial damageNTSB MIA81DLD58Accident · No injuriesClosedPiper PA-28 · Long Boat Key, FLAug 25, 1981 · N8788N · DestroyedNTSB MIA81DKJ16Accident · No injuriesClosedPiper PA-24 · Panama City, FLAug 24, 1981 · N8966P · Substantial damageNTSB MIA81FKT90Accident · No injuriesClosedPiper PA-31 · Ft.Lauderdale, FLAug 23, 1981 · N9100Y · Substantial damageNTSB MIA81FA107Accident · 2 fatalClosedPiper J5A · Carrabelle, FLAug 22, 1981 · N41220 · DestroyedNTSB MIA81DLD62Accident · Minor injuriesClosedPiper PA-22 · Captiva, FLAug 22, 1981 · N3736Z · DestroyedNTSB MIA81DKJ15Accident · No injuriesClosedBellanca 8GCBC · Destin, FLAug 21, 1981 · N86985 · Substantial damageNTSB MIA81AA106Accident · Minor injuriesClosedBoeing 727 · Ft.Lauderdale, FLAug 17, 1981 · N4742 · Substantial damageNTSB MIA81FKT88Accident · Minor injuriesClosedLake LA-4 · Tavernier, FLAug 15, 1981 · N11481 · DestroyedNTSB MIA81FA104Accident · 2 fatalClosedBeech H18 · Ft.Lauderdale, FLAug 13, 1981 · N518K · DestroyedNTSB MIA81IA103Incident · No injuriesClosedLockheed L-1011 · Ft.Lauderdale, FLAug 10, 1981 · N726DA · Minor damageNTSB MIA81DLD61Accident · No injuriesClosedCessna T188C · Romeo, FLAug 10, 1981 · N2541J · Substantial damageNTSB MIA82FA025Accident · 2 fatalClosedPiper PA-23 · Bunnell, FLAug 8, 1981 · N14185 · DestroyedNTSB MIA81DLA31Accident · Serious injuriesClosedBellanca 8GCBC · Ormond Beach, FLAug 8, 1981 · N88298 · DestroyedNTSB MIA81DKT89Accident · No injuriesClosedPiper PA-31 · Homestead, FLAug 5, 1981 · N7946 · DestroyedNTSB MIA81DKT86Accident · No injuriesClosedCessna 150 · Key West, FLAug 5, 1981 · N23318 · Substantial damageNTSB MIA81FLD60Accident · Serious injuriesClosedAeronca 7DC · Okeechobee, FLAug 2, 1981 · N83633 · DestroyedNTSB MIA81DKT85Accident · Minor injuriesClosedCessna 152 · Palm Beach, FLAug 2, 1981 · N48889 · Substantial damageNTSB MIA81FLD57Accident · Serious injuriesClosedCessna 172N · Chuluota, FLJul 30, 1981 · N737MV · DestroyedNTSB MIA81FA102Accident · 2 fatalClosedBeech 65-B80 · Groveland, FLJul 28, 1981 · N1028C · DestroyedNTSB MIA81FA101Accident · No injuriesClosedCessna P206A · Marathon, FLJul 28, 1981 · N4621F · Substantial damageNTSB MIA81DLD59Accident · No injuriesClosedBurkhart G-10Z · Haines, FLJul 26, 1981 · N14855 · DestroyedNTSB MIA81DA108Accident · No injuriesClosedMooney M20K · Defuniak Sprgs, FLJul 25, 1981 · N231GE · Substantial damageNTSB MIA81DKJ13Accident · No injuriesClosedBeech C-24R · Crestview, FLJul 23, 1981 · N5070M · Substantial damageNTSB MIA81FLD56Accident · No injuriesClosedBeech 56TC · Arcadia, FLJul 19, 1981 · N6241V · Substantial damageNTSB MIA81FLD55Accident · No injuriesClosedCessna 182 · Tampa, FLJul 19, 1981 · N3154Y · Substantial damageNTSB MIA81FA096Accident · 3 fatalClosedBeech B95 · Titusville, FLJul 19, 1981 · N27GD · DestroyedNTSB MIA81FLD54Accident · Minor injuriesClosedCessna 172 · Sebastian Inlt, FLJul 17, 1981 · N738VF · Substantial damageNTSB MIA81FA095Accident · 1 fatalClosedPiper PA-28 · Palm Bay, FLJul 15, 1981 · N56731 · DestroyedNTSB MIA81FLD53Accident · Serious injuriesClosedCessna 172 · Tampa, FLJul 12, 1981 · N5319H · DestroyedNTSB MIA81FA093Accident · 2 fatalClosedPiper PA-28 · Lakeland, FLJul 12, 1981 · N8487R · DestroyedNTSB MIA81FA094Accident · 3 fatalClosedPiper PA-32R · Naples, FLJul 11, 1981 · N6074H · DestroyedNTSB MIA81FKT84Accident · No injuriesClosedCessna 172 · Clewiston, FLJul 8, 1981 · N21807 · DestroyedNTSB MIA81FA091Accident · No injuriesClosedPiper PA-28R · Jacksonville, FLJul 8, 1981 · N29312 · Substantial damageNTSB MIA81DLA30Accident · No injuriesClosedBellanca 7ECA · Ormond Beach, FLJul 8, 1981 · N9179L · Substantial damageNTSB MIA81FLD51Accident · Minor injuriesClosedPiper PA-34 · Deer Park, FLJul 6, 1981 · N92T · DestroyedNTSB MIA81DLD52Accident · No injuriesClosedCessna 182 · Brooksville, FLJul 5, 1981 · N3842D · Substantial damageNTSB MIA81DKJ12Accident · No injuriesClosedCessna 172M · Marianna, FLJul 4, 1981 · N1576V · Substantial damageNTSB MIA81FA090Accident · 1 fatalClosedMooney M20J · St.Petersburg, FLJul 1, 1981 · N1138K · Destroyed