NTSB investigations, 1981, FL

48 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1981, FL per year, 1962–2026: 3,027 cases
19624
19633
196477
1965113
196694
1967121
196883
196972
197066
197172
197293
197390
197481
197559
197662
197772
197879
197968
198067
198148
198255
198344
198453
198545
198662
198759
198848
198952
199028
199126
199227
199330
199441
199528
199627
199729
199845
199931
200033
200135
200232
200328
200436
200550
200650
200748
200840
200925
201025
201133
201222
201322
201443
201533
201626
201734
201842
201934
202029
202129
202221
202321
202428
202529
202625

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 = 550)
  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 MIA82DLD11Accident · No injuriesClosedCessna 150L · Cedar Key, FLDec 19, 1981 · N1578Q · DestroyedNTSB MIA82DLA04Accident · No injuriesClosedSonera1 II · Bunnell, FLDec 19, 1981 · N55843 · Substantial damageNTSB MIA82FA022Accident · No injuriesClosedBoeing 707 · Miami, FLDec 16, 1981 · HI-384 · Substantial damageNTSB MIA82DLA02Accident · No injuriesClosedMooney M-18L · St.Augustine, FLOct 17, 1981 · N396A · Substantial damageNTSB MIA82IA002Accident · No injuriesClosedBeech G18S · Jacksonville, FLOct 12, 1981 · N5BA · Substantial damageNTSB MIA81DKT99Accident · No injuriesClosedCessna 337 · Key West, FLSep 21, 1981 · N72242 · Substantial damageNTSB MIA81DLD67Accident · No injuriesClosedBeech B95 · Sanford, FLSep 20, 1981 · N9619R · Substantial damageNTSB MIA81DKT81Accident · No injuriesClosedGrumman AF-2S · Miami, FLSep 20, 1981 · YV-398A · Substantial damageNTSB MIA81DLA35Accident · No injuriesClosedLake LA-4 · Gainesville, FLSep 13, 1981 · N2528P · Substantial damageNTSB MIA81FLD64Accident · Minor injuriesClosedBellanca 17-31 · Melbourne, FLSep 7, 1981 · N1004R · 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 MIA81FA111Accident · No injuriesClosedBoeing 727 · Miami, FLAug 25, 1981 · 6Y-JMB · Substantial damageNTSB MIA81DKJ15Accident · No injuriesClosedBellanca 8GCBC · Destin, FLAug 21, 1981 · N86985 · Substantial damageNTSB MIA81DLD59Accident · No injuriesClosedBurkhart G-10Z · Haines, FLJul 26, 1981 · N14855 · DestroyedNTSB MIA81FLD54Accident · Minor injuriesClosedCessna 172 · Sebastian Inlt, FLJul 17, 1981 · N738VF · Substantial damageNTSB 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 MIA81FLA29Accident · Minor injuriesClosedCessna 182 · Deland, FLJun 27, 1981 · N1776Y · DestroyedNTSB MIA81DLA21Accident · No injuriesClosedCessna 152 · Waldo, FLJun 22, 1981 · N89768 · Substantial damageNTSB MIA81FLD49Accident · No injuriesClosedCessna 152 · Clearwater, FLJun 17, 1981 · N757YZ · Substantial damageNTSB MIA81DKT77Accident · No injuriesClosedCessna 172M · Key West, FLJun 12, 1981 · N9109H · Substantial damageNTSB MIA81DLA27Accident · No injuriesClosedCessna 172 · Keystone Hgts, FLMay 28, 1981 · N5309K · Substantial damageNTSB MIA81FLD44Accident · No injuriesClosedMitsubishi MU-2B · Lakeland, FLMay 21, 1981 · N741MA · Substantial damageNTSB MIA81DLA26Accident · No injuriesClosedCessna 172RG · Perry, FLMay 20, 1981 · N6117R · Substantial damageNTSB MIA81DLA25Accident · No injuriesClosedCessna 150 · Jacksonville, FLMay 20, 1981 · N704RB · Substantial damageNTSB MIA81DLA23Accident · No injuriesClosedBeech P35 · Deland, FLMay 12, 1981 · N1746G · Substantial damageNTSB MIA81FA070Accident · No injuriesClosedAerostar 600 · Orlando, FLMay 6, 1981 · N79CM · Substantial damageNTSB MIA81FKT50Accident · No injuriesClosedCessna 335 · Ft.Lauderdale, FLMay 1, 1981 · N2710F · Substantial damageNTSB MIA81DLA22Accident · Serious injuriesClosedCessna 140 · Quiney, FLApr 30, 1981 · N72586 · Substantial damageNTSB MIA81DLD34Accident · No injuriesClosedAero Comdr 100 · Crystal River, FLApr 27, 1981 · N3779X · Substantial damageNTSB MIA81DLD36Accident · No injuriesClosedBeech V-35A · St.Petersburg, FLApr 25, 1981 · N221AB · Substantial damageNTSB MIA81DLD32Accident · No injuriesClosedCessna 152 · Odessa, FLApr 25, 1981 · N4733B · Substantial damageNTSB MIA81DLA20Accident · No injuriesClosedRobinson R22 · Gainesville, FLApr 23, 1981 · N9022Z · Substantial damageNTSB MIA81FA067Accident · No injuriesClosedCessna 172 · Venice, FLApr 19, 1981 · N5211E · 2 aircraft · Substantial damageNTSB MIA81DKT45Accident · No injuriesClosedHughes 269C · Miami, FLApr 18, 1981 · N10926 · Substantial damageNTSB MIA81FLA19Accident · No injuriesClosedStarduster TOO · Jacksonville, FLApr 9, 1981 · N333Q · Substantial damageNTSB MIA81DLA17Accident · No injuriesClosedCessna 172 · Daytona Beach, FLApr 4, 1981 · N7602D · Substantial damageNTSB MIA81FA060Accident · 2 fatalClosedPiper PA-28 · Lakeland, FLApr 2, 1981 · N8235H · DestroyedNTSB MIA81DLD29Accident · No injuriesClosedCessna 152 · Orange Springs, FLMar 30, 1981 · N48390 · Substantial damageNTSB MIA81DLA14Accident · No injuriesClosedPiper PA-44 · Daytona Beach, FLMar 28, 1981 · N2196B · Substantial damageNTSB MIA81FLD25Accident · No injuriesClosedBeech 58 · Clearwater, FLFeb 17, 1981 · N9094Q · Substantial damageNTSB MIA81DLD24Accident · No injuriesClosedPiper PA-28 · Silver Springs, FLFeb 17, 1981 · N5726U · Substantial damageNTSB MIA81FLA12Accident · No injuriesClosedPiper PA-28R · Jacksonville, FLJan 30, 1981 · N15546 · Substantial damage