NTSB investigations, 2000
451 cases where the phase of flight was Enroute.
Cases, newest first
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\") = 2000
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") = 2000
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 ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB CHI01LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…NTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.NTSB NYC01LA026Accident · Serious injuriesLimited investigationFinal reportDever Firefly · Berlin, NJA loss of power for undetermined reasons.NTSB NYC01LA028Accident · No injuriesLimited investigationFinal reportBeech A-36 · Millersburg, OHThe pilot' failure to properly manage the available fuel onboard, which result in fuel starvation, and a loss of engine power.NTSB FTW01LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Almyra, ARthe loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.NTSB CHI01LA030Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Worth, ILThe pilot's inadequate preflight of the airplane and his failure to verify the fuel supply on board, which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the lack of suitable…NTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.NTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.NTSB FTW01FA017Accident · 1 fatalField investigationFinal reportAerospatiale AS-350BA · E. Cameron 200the loss of engine power due to an internal engine oil leak that started an internal engine fire and the pilot's inadequate autorotation which resulted in a hard landing. A contributing factor to the accident was the rough water condition.NTSB NYC01LA027Accident · No injuriesLimited investigationFinal reportO Loughlin WAG-A-BOND · Greenville, METotal loss of engine power for undetermined reasons.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB LAX01FA026Accident · 2 fatalField investigationFinal reportCessna 340A · Julian, CATotal blockage of the instrument static system due to ice.NTSB LAX01LA022Accident · Serious injuriesLimited investigationFinal reportBeech 35B33 · Bullhead City, AZThe pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB IAD01IA009Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Morristown, NJThe failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.NTSB LAX01LA025Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350BA · Kamuela, HIA total loss of engine power due to the failure of the engine manufacturer's repair station personnel to install a circlip during engine overhaul, which resulted in the turbine assembly aft support bearing becoming dislodged and seized on the shaft. A factor…NTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…NTSB NYC01FA021Accident · 3 fatalField investigationFinal reportBeech BE-23-24 · Kingston, OHThe pilot's failure to check both fuel tanks visually during the preflight inspection. A factor in the accident was the dark night.NTSB MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.NTSB IAD01LA008Accident · Minor injuriesLimited investigationFinal reportConn Sonerai II · Manassas, VAFuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.NTSB IAD01LA007Accident · No injuriesLimited investigationFinal reportCessna 140 · Mcclure, PAThe loss of engine power over unsuitable terrain due to fuel starvation from a fuel strainer blocked with sealant particles.NTSB IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.NTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.NTSB ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, MIthe pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.NTSB DEN01FA003Accident · 1 fatalField investigationFinal reportCessna R-182 · Grants, NMthe pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.NTSB MIA01LA002Accident · No injuriesLimited investigationFinal reportHarwell/Gardner WAG-AERO Cubby · Stockbridge, GAThe pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.NTSB FTW01FA007Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Cotulla, TXThe pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.NTSB LAX01FA006Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369E · Kernville, CAThe pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.NTSB CHI01LA003Accident · No injuriesLimited investigationFinal reportCessna 182 · Noblesville, INCarburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.NTSB CHI01LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sparta, WIthe pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…NTSB ANC01LA003Accident · Minor injuriesLimited investigationFinal reportHelio H-295 · Port Alsworth, AKThe pilot's inadequate preflight inspection, which failed to remove all water from the fuel system. A factor associated with the accident was unsuitable terrain for a forced landing.NTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.NTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.NTSB FTW01LA005Accident · 2 fatalLimited investigationFinal reportHolt Thorpe T-18C · Imperial, TXthe failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.NTSB CHI01LA002Accident · 1 fatalLimited investigationFinal reportMoseler RAF 2000 GTX SE · Muskegon, MIThe main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.NTSB ATL01LA004Accident · No injuriesLimited investigationFinal reportJoseph A. Grimaud Seawind 3000 · Chapin, SCA total loss of engine power for undetermined reasons. A factor was the trees.NTSB NYC01LA002Accident · Serious injuriesLimited investigationFinal reportMaule M-5 · Leicester, MAThe pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.NTSB LAX01FA001Accident · 4 fatalField investigationFinal reportBeech A36TC · San Juan Batist, CAthe pilot's in-flight decision to continue flight into instrument weather conditions at an altitude that did not maintain an adequate terrain clearance, which resulted in a collision with terrain. Factors were a dark night, clouds, fog, mountainous terrain,…NTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.NTSB LAX00FA354Accident · 1 fatalField investigationFinal reportPiper PA-38 · San Luis Obispo, CAThe pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.