NTSB investigations, 1981, FL
48 cases where the phase of flight was Landing.
Cases per year
| 1962 | 4 |
|---|---|
| 1963 | 3 |
| 1964 | 77 |
| 1965 | 113 |
| 1966 | 94 |
| 1967 | 121 |
| 1968 | 83 |
| 1969 | 72 |
| 1970 | 66 |
| 1971 | 72 |
| 1972 | 93 |
| 1973 | 90 |
| 1974 | 81 |
| 1975 | 59 |
| 1976 | 62 |
| 1977 | 72 |
| 1978 | 79 |
| 1979 | 68 |
| 1980 | 67 |
| 1981 | 48 |
| 1982 | 55 |
| 1983 | 44 |
| 1984 | 53 |
| 1985 | 45 |
| 1986 | 62 |
| 1987 | 59 |
| 1988 | 48 |
| 1989 | 52 |
| 1990 | 28 |
| 1991 | 26 |
| 1992 | 27 |
| 1993 | 30 |
| 1994 | 41 |
| 1995 | 28 |
| 1996 | 27 |
| 1997 | 29 |
| 1998 | 45 |
| 1999 | 31 |
| 2000 | 33 |
| 2001 | 35 |
| 2002 | 32 |
| 2003 | 28 |
| 2004 | 36 |
| 2005 | 50 |
| 2006 | 50 |
| 2007 | 48 |
| 2008 | 40 |
| 2009 | 25 |
| 2010 | 25 |
| 2011 | 33 |
| 2012 | 22 |
| 2013 | 22 |
| 2014 | 43 |
| 2015 | 33 |
| 2016 | 26 |
| 2017 | 34 |
| 2018 | 42 |
| 2019 | 34 |
| 2020 | 29 |
| 2021 | 29 |
| 2022 | 21 |
| 2023 | 21 |
| 2024 | 28 |
| 2025 | 29 |
| 2026 | 25 |
Where
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.
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" DESCRun 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 MIA82DLD11Accident · No injuriesClosedCessna 150L · Cedar Key, FLNTSB MIA82DLA04Accident · No injuriesClosedSonera1 II · Bunnell, FLNTSB MIA82FA022Accident · No injuriesClosedBoeing 707 · Miami, FLNTSB MIA82DLA02Accident · No injuriesClosedMooney M-18L · St.Augustine, FLNTSB MIA82IA002Accident · No injuriesClosedBeech G18S · Jacksonville, FLNTSB MIA81DKT99Accident · No injuriesClosedCessna 337 · Key West, FLNTSB MIA81DLD67Accident · No injuriesClosedBeech B95 · Sanford, FLNTSB MIA81DKT81Accident · No injuriesClosedGrumman AF-2S · Miami, FLNTSB MIA81DLA35Accident · No injuriesClosedLake LA-4 · Gainesville, FLNTSB MIA81FLD64Accident · Minor injuriesClosedBellanca 17-31 · Melbourne, 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 MIA81FA111Accident · No injuriesClosedBoeing 727 · Miami, FLNTSB MIA81DKJ15Accident · No injuriesClosedBellanca 8GCBC · Destin, FLNTSB MIA81DLD59Accident · No injuriesClosedBurkhart G-10Z · Haines, FLNTSB MIA81FLD54Accident · Minor injuriesClosedCessna 172 · Sebastian Inlt, 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 MIA81FLA29Accident · Minor injuriesClosedCessna 182 · Deland, FLNTSB MIA81DLA21Accident · No injuriesClosedCessna 152 · Waldo, FLNTSB MIA81FLD49Accident · No injuriesClosedCessna 152 · Clearwater, FLNTSB MIA81DKT77Accident · No injuriesClosedCessna 172M · Key West, FLNTSB MIA81DLA27Accident · No injuriesClosedCessna 172 · Keystone Hgts, FLNTSB MIA81FLD44Accident · No injuriesClosedMitsubishi MU-2B · Lakeland, FLNTSB MIA81DLA26Accident · No injuriesClosedCessna 172RG · Perry, FLNTSB MIA81DLA25Accident · No injuriesClosedCessna 150 · Jacksonville, FLNTSB MIA81DLA23Accident · No injuriesClosedBeech P35 · Deland, FLNTSB MIA81FA070Accident · No injuriesClosedAerostar 600 · Orlando, FLNTSB MIA81FKT50Accident · No injuriesClosedCessna 335 · Ft.Lauderdale, FLNTSB MIA81DLA22Accident · Serious injuriesClosedCessna 140 · Quiney, FLNTSB MIA81DLD34Accident · No injuriesClosedAero Comdr 100 · Crystal River, FLNTSB MIA81DLD36Accident · No injuriesClosedBeech V-35A · St.Petersburg, FLNTSB MIA81DLD32Accident · No injuriesClosedCessna 152 · Odessa, FLNTSB MIA81DLA20Accident · No injuriesClosedRobinson R22 · Gainesville, FLNTSB MIA81FA067Accident · No injuriesClosedCessna 172 · Venice, FLNTSB MIA81DKT45Accident · No injuriesClosedHughes 269C · Miami, FLNTSB MIA81FLA19Accident · No injuriesClosedStarduster TOO · Jacksonville, FLNTSB MIA81DLA17Accident · No injuriesClosedCessna 172 · Daytona Beach, FLNTSB MIA81FA060Accident · 2 fatalClosedPiper PA-28 · Lakeland, FLNTSB MIA81DLD29Accident · No injuriesClosedCessna 152 · Orange Springs, FLNTSB MIA81DLA14Accident · No injuriesClosedPiper PA-44 · Daytona Beach, FLNTSB MIA81FLD25Accident · No injuriesClosedBeech 58 · Clearwater, FLNTSB MIA81DLD24Accident · No injuriesClosedPiper PA-28 · Silver Springs, FLNTSB MIA81FLA12Accident · No injuriesClosedPiper PA-28R · Jacksonville, FL