NTSB investigations, 1981, FL

55 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 1981, FL per year, 1962–2026: 2,183 cases
19621
19632
196426
196530
196635
196737
196845
196933
197053
197142
197243
197361
197438
197550
197639
197751
197855
197954
198058
198155
198254
198352
198459
198558
198664
198746
198841
198937
199037
199138
199237
199335
199440
199543
199638
199735
199831
199942
200025
200125
200231
200333
200431
200535
200622
200739
200819
200929
201018
201113
201222
201317
201413
201513
201620
201718
201822
201914
202012
202123
202216
202315
202424
202520
202619

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 MIA82FLD12Accident · No injuriesClosedCessna T210N · Haines City, FLDec 31, 1981 · N6605Y · Substantial damageNTSB MIA82FA027Accident · 1 fatalClosedBeech 95 · Belleview, FLDec 30, 1981 · N103E · DestroyedNTSB MIA82DLA06Accident · No injuriesClosedPiper PA-28 · St.Augustine, FLDec 29, 1981 · N7114R · DestroyedNTSB MIA82FKT04Accident · Serious injuriesClosedCessna T337G · Palm Beach, FLNov 25, 1981 · N55C · DestroyedNTSB MIA82FKT02Accident · Minor injuriesClosedHughes 369HS · Sunrise, FLNov 23, 1981 · N9071F · DestroyedNTSB MIA82DLD08Accident · No injuriesClosedCessna 182 · Vero Beach, FLNov 22, 1981 · N71335 · DestroyedNTSB MIA82FLD05Accident · No injuriesClosedPiper PA-28 · Titusville, FLNov 12, 1981 · N57364 · Substantial damageNTSB MIA82DLA03Accident · No injuriesClosedCessna A188B · Carrabelle, FLOct 31, 1981 · N731EL · DestroyedNTSB MIA82FKJ01Incident · No injuriesClosedPiper PA-23 · Pensacola, FLOct 29, 1981 · N2589B · Minor damageNTSB MIA82FLD01Accident · Serious injuriesClosedPiper PA-18A · Ft Pierce, FLOct 12, 1981 · N4890A · DestroyedNTSB MIA81FKT01Accident · Minor injuriesClosedCessna P210N · Miami, FLOct 3, 1981 · N4739K · DestroyedNTSB MIA81FA124Accident · 2 fatalClosedPiper PA-23 · Daytona Beach, FLSep 29, 1981 · N62628 · DestroyedNTSB MIA81FA123Accident · 1 fatalClosedBeech M35 · Lake Worth, FLSep 24, 1981 · N9997R · DestroyedNTSB MIA81FA122Accident · 2 fatalClosedCessna 150G · Ponce De Leon, FLSep 23, 1981 · N3836J · DestroyedNTSB MIA81FKU04Accident · No injuriesClosedPiper PA-31 · Miami, FLSep 21, 1981 · N75541 · Substantial damageNTSB MIA81DKT97Accident · No injuriesClosedCessna 414A · Homestead, FLSep 19, 1981 · N90673 · DestroyedNTSB MIA81DLA34Accident · Minor injuriesClosedPiper PA-22 · High Springs, FLSep 12, 1981 · N3258Z · 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 MIA81FKT81Accident · No injuriesClosedBeech D18S · Palm Beach, FLAug 27, 1981 · N25V · 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 MIA81DLD62Accident · Minor injuriesClosedPiper PA-22 · Captiva, FLAug 22, 1981 · N3736Z · DestroyedNTSB MIA81IA103Incident · No injuriesClosedLockheed L-1011 · Ft.Lauderdale, FLAug 10, 1981 · N726DA · Minor damageNTSB MIA81DLA31Accident · Serious injuriesClosedBellanca 8GCBC · Ormond Beach, FLAug 8, 1981 · N88298 · DestroyedNTSB MIA81DKT85Accident · Minor injuriesClosedCessna 152 · Palm Beach, FLAug 2, 1981 · N48889 · Substantial damageNTSB MIA81FLD57Accident · Serious injuriesClosedCessna 172N · Chuluota, FLJul 30, 1981 · N737MV · DestroyedNTSB MIA81DA108Accident · No injuriesClosedMooney M20K · Defuniak Sprgs, FLJul 25, 1981 · N231GE · Substantial damageNTSB MIA81FLD56Accident · No injuriesClosedBeech 56TC · Arcadia, FLJul 19, 1981 · N6241V · Substantial damageNTSB MIA81FLD55Accident · No injuriesClosedCessna 182 · Tampa, FLJul 19, 1981 · N3154Y · Substantial damageNTSB MIA81FA093Accident · 2 fatalClosedPiper PA-28 · Lakeland, FLJul 12, 1981 · N8487R · DestroyedNTSB MIA81FA089Accident · 2 fatalClosedCessna 172P · Hollister, FLJun 30, 1981 · N52484 · DestroyedNTSB MIA81FKT78Accident · No injuriesClosedCessna 210N · Key Largo, FLJun 11, 1981 · N6418N · Substantial damageNTSB MIA81FA083Accident · 1 fatalClosedAero Comdr 500 · Flagler Beach, FLJun 11, 1981 · N711MK · DestroyedNTSB MIA81FKT74Accident · No injuriesClosedPiper PA-28 · Ft.Lauderdale, FLJun 10, 1981 · N4762F · Substantial damageNTSB MIA81DLA28Accident · Minor injuriesClosedBellanca 7GCBC · New Smyrna Bch, FLJun 6, 1981 · N87069 · Substantial damageNTSB MIA81DKT49Accident · No injuriesClosedCessna 150 · Key Largo, FLJun 6, 1981 · N8252F · DestroyedNTSB MIA81FLD50Accident · No injuriesClosedPiper PA-31 · Fort Myers, FLJun 5, 1981 · N747CE · Substantial damageNTSB MIA81DKJ07Accident · No injuriesClosedBellanca 7GCAA · Panama City, FLMay 21, 1981 · N88357 · Substantial damageNTSB MIA81FA072Accident · No injuriesClosedMitsubishi MU-2 · Miami, FLMay 13, 1981 · N92JR · DestroyedNTSB MIA81DLD35Accident · Minor injuriesClosedDehavilland DH-104 · Sebring, FLMay 1, 1981 · N630H · DestroyedNTSB MIA81FKJ06Accident · No injuriesClosedCessna 172 · Defuniak Spgs, FLApr 10, 1981 · N8127X · Substantial damageNTSB MIA81FLA18Accident · Minor injuriesClosedCessna 210L · Lake City, FLApr 7, 1981 · N5494V · Substantial damageNTSB MIA81FLD30Accident · No injuriesClosedPiper PA-12 · Indian Rocks, FLApr 5, 1981 · N2846M · DestroyedNTSB MIA81FA062Accident · Serious injuriesClosedHiller UH-12E · Miami, FLApr 3, 1981 · N62360 · DestroyedNTSB MIA81FA055Accident · No injuriesClosedN.American P51D · Tallahassee, FLMar 24, 1981 · N3451D · 2 aircraft · Minor damageNTSB MIA81FA053Accident · Minor injuriesClosedHiller UH-12D · Miami Beach, FLMar 20, 1981 · N62376 · DestroyedNTSB MIA81FKT31Accident · No injuriesClosedHiller Acft UH-12D · Miami, FLMar 8, 1981 · N62362 · Substantial damageNTSB MIA81DKT32Accident · Minor injuriesClosedBeech 23 · Naples, FLMar 8, 1981 · N3547R · DestroyedNTSB MIA81FKT29Accident · No injuriesClosedBeech 65-88 · Ft.Lauderdale, FLMar 1, 1981 · N440R · Destroyed