NTSB investigations, 2003, GA
17 cases where the phase of flight was Enroute.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 8 |
| 1965 | 18 |
| 1966 | 14 |
| 1967 | 22 |
| 1968 | 20 |
| 1969 | 24 |
| 1970 | 22 |
| 1971 | 31 |
| 1972 | 29 |
| 1973 | 15 |
| 1974 | 26 |
| 1975 | 18 |
| 1976 | 16 |
| 1977 | 30 |
| 1978 | 22 |
| 1979 | 22 |
| 1980 | 24 |
| 1981 | 21 |
| 1982 | 27 |
| 1983 | 12 |
| 1984 | 18 |
| 1985 | 18 |
| 1986 | 16 |
| 1987 | 12 |
| 1988 | 11 |
| 1989 | 12 |
| 1990 | 19 |
| 1991 | 16 |
| 1992 | 13 |
| 1993 | 6 |
| 1994 | 9 |
| 1995 | 11 |
| 1996 | 10 |
| 1997 | 16 |
| 1998 | 14 |
| 1999 | 7 |
| 2000 | 12 |
| 2001 | 17 |
| 2002 | 10 |
| 2003 | 17 |
| 2004 | 8 |
| 2005 | 8 |
| 2006 | 16 |
| 2007 | 18 |
| 2008 | 6 |
| 2009 | 11 |
| 2010 | 7 |
| 2011 | 8 |
| 2012 | 6 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 9 |
| 2022 | 10 |
| 2023 | 7 |
| 2024 | 11 |
| 2025 | 3 |
| 2026 | 4 |
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\") = 2003
AND c.\"eventStateOrRegion\" = 'GA' 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.
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") = 2003
AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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 ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.NTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.NTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.NTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.NTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.NTSB ATL03FA089Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Calhoun, GAThe pilot's failure to obtain a preflight weather briefing, which would have indicated that MVFR to IFR conditions prevailed over the route with embedded thunderstorms and rain, and his decision to continue VFR flight into instrument meteorological…NTSB CHI03LA113Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Lithonia, GAThe flight into adverse weather encountered by the flight crew, and the flight attendant's restraint not available when she was informed to take her seat. The convective associated turbulence was a contributing factor.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB ATL03FA068Accident · 2 fatalField investigationFinal reportRockwell 690B · Homerville, GAAn in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.NTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.NTSB ATL03FA049Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Sylvania, GAThe pilot's decision to conduct VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Related factors were the guy wire and the fog.NTSB ATL03LA036Accident · No injuriesLimited investigationFinal reportBeech 65 · Fitzgerald, GAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the loss of engine power in both engines. A factor was a tree.NTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.NTSB MIA03LA035Accident · Minor injuriesLimited investigationFinal reportLonnie Johnson RV6A · Peachtree City, GAThe failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced…