OpenAirDocs.org

NTSB investigations

35,885 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 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 ATL01LA090Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20C · Etowah, TNThe loss of thermal lift which resulted in a forced landing and subsequent in-flight collision with static wires.Jul 21, 2001 · N9HK · Substantial damageNTSB FTW01LA166Accident · Serious injuriesLimited investigationFinal reportEurocopter BK117-C1 · Decatur, TXthe pilot's failure to follow the checklist and turn on the fuel transfer pumps, which resulted in fuel starvation and a dual loss of engine power while in cruise flight.Jul 20, 2001 · N313LS · Substantial damageNTSB CHI01LA225Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Freemont, MIThe broken throttle cable during cruise flight and the pilot's inadequate flare during the forced landing attempt. Factors relating to this accident were the low airspeed during the forced landing attempt and the short, corn stubble field.Jul 20, 2001 · N756DM · Substantial damageNTSB CHI01FA220Accident · 1 fatalField investigationFinal reportMooney M-20R · Eden Prairie, MNThe fractured camshaft gear and the pilot not maintaining aircraft control. Factors relating to this accident were metal fatigue in the camshaft gear teeth, the inadvertent stall, the low airspeed, and the trees.Jul 19, 2001 · N2HW · DestroyedNTSB CHI01LA219Accident · No injuriesLimited investigationFinal reportCessna 172C · Grand Island, NEThe procedures for using carburetor heat not followed by the student pilot and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing conditions, the carburetor icing, the student pilot's lack of…Jul 18, 2001 · N1860Y · Substantial damageNTSB ATL01LA085Accident · No injuriesLimited investigationFinal reportCessna 172M · Atlantic Ocean (Atlantic Ocean)The loss of engine power for undetermined reasons.Jul 18, 2001 · N13237 · Substantial damageNTSB ANC01TA087Accident · No injuriesFinal reportde Havilland DHC-2 · Willow, AKThe loss of engine power during cruise due to the separation of an engine cylinder.Jul 18, 2001 · N9262Z · Substantial damageNTSB NYC01LA177Accident · Serious injuriesLimited investigationFinal reportRaum Rans S-12 · Waldorf, MDFuel contamination. A factor related to the accident was the builder’s decision to not install fuel tank drains.Jul 16, 2001 · N40R · Substantial damageNTSB NYC01LA176Accident · No injuriesLimited investigationFinal reportCessna 182 · Warren, OHThe pilot's failure to adequately manage the available fuel, which resulted in fuel starvation.Jul 15, 2001 · N2815R · Substantial damageNTSB MIA01LA185Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mooresville, NCthe pilot's improper fuel consumption calculations, inadequate preflight planning, and failure to refuel the airplane before takeoff, which resulted in a loss of engine power due to fuel exhaustion, and a forced landing in trees.Jul 15, 2001 · N8861E · DestroyedNTSB MIA01LA190Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S MXL II Sport · Arroyo, PRthe pilots failure to maintain directional control during climb, which resulted in the airplane drifting off course and impacting with trees.Jul 14, 2001 · N4305C · Substantial damageNTSB MIA01LA186Accident · Serious injuriesLimited investigationFinal reportPitenpol Aircamper 1933 · Hernando, FLThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.Jul 14, 2001 · N1777W · DestroyedNTSB MIA01LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Boca Raton, FLA loss of engine power, and the pilot unable to feather the propeller for undetermined reasons, which resulted in a forced landing on a highway, subsequent impact with a pole and vehicles.Jul 12, 2001 · N3054J · Substantial damageNTSB LAX01LA307Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · San Francisco, CAthe captain's excessive use of the flight controls to level off from a descent, which resulted in a passenger injury.Jul 12, 2001 · N644DL · No damageNTSB LAX01LA243Accident · No injuriesLimited investigationFinal reportBell 206B · San Francisco, CAThe failure of the accessory gearbox 2 1/2 bearing in fatigue resulting in the complete loss of engine power and a subsequent forced landing. The pilot's failure to maintain directional control during the autorotational flare maneuver is also causal. The…Jul 12, 2001 · N474SF · Substantial damageNTSB CHI01IA211Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Whiteman AFB, MOThe separation of a fan blade due to fatigue failure which led to case separation and loss of engine power in the left engine.Jul 12, 2001 · N9413T · Minor damageNTSB SEA01LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R · Cut Bank, MTThe pilot's failure to maintain a speed above stall velocity (Vs) during the after-takeoff climb. Factors include a high density altitude, and a dust devil/whirlwind located along the route of departure.Jul 10, 2001 · N8475C · Substantial damageNTSB NYC01LA168Accident · No injuriesLimited investigationFinal reportBell 206B · Secaucus, NJUnder torque of a Thomas coupling self-locking nut for undetermined reasons, which resulted in the loss of the corresponding retaining bolt, and subsequent separation of tail rotor drive shaft segments. A factor was the unsuitable terrain beneath the pilot…Jul 10, 2001 · N3298G · Substantial damageNTSB ATL01LA075Accident · No injuriesLimited investigationFinal reportBell 47 · Indianola, MSThe pilot's improper use of flight controls during an autorotation that resulted inn the collapse of the skids and cross tube assembly. A factor was the loss of engine power due to the failure of # 1 connecting rod and the overload failure of the skids and…Jul 10, 2001 · N8478D · Substantial damageNTSB NYC01LA167Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Clay, NYFailure of the left aft cluster fitting due to a fatigue crack. Factors in the accident were the mechanic's failure to identify the crack at the last annual inspection, and the pilot's failure to identify the crack during the last daily inspectionJul 9, 2001 · N7028V · Substantial damageNTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.Jul 9, 2001 · N7332F · Substantial damageNTSB LAX01LA237Accident · 1 fatalLimited investigationFinal reportAeronca O-58B · San Andreas, CAAn in-flight collision with terrain for undetermined reasons.Jul 6, 2001 · N50912 · Substantial damageNTSB ATL01LA074Accident · No injuriesLimited investigationFinal reportCessna 208B · Ft. Lauderdale, FLThe undetermined malfunction of the propeller system.Jul 6, 2001 · N812MA · DestroyedNTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.Jul 4, 2001 · N5142D · Substantial damageNTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..Jul 3, 2001 · N6475T · Substantial damageNTSB CHI01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mecosta, MIthe inadequate preflight planning/preparation by the pilot and fuel starvation. Additional causes were the aircraft control not maintained, and the inadvertent stall by the pilot.Jul 3, 2001 · N8007N · DestroyedNTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.Jul 2, 2001 · N9077Q · Substantial damageNTSB ANC01LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKA fire of undetermined origin, following a precautionary landing.Jul 2, 2001 · N4989A · DestroyedNTSB LAX01LA231Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder City, NVthe loss of engine power while in cruise flight due to the mechanic's improper magneto timing.Jul 1, 2001 · N737SH · Substantial damageNTSB DEN01LA119Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COfailure of the nose landing gear hydraulic UP hose, which resulted in a wheels-up landing..Jul 1, 2001 · N2129Q · Substantial damageNTSB ANC01LA080Accident · No injuriesLimited investigationFinal reportBeech H35 · Chitina, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and a downdraft.Jul 1, 2001 · N5429D · Substantial damageNTSB CHI01LA192Accident · Minor injuriesLimited investigationFinal reportMelenyk Genesis · Howell, MIthe in-flight planning/decision by the pilot. Contributing factors were the undetermined loss of engine power, the quartering tailwind and the unsuitable terrain encountered by the pilot.Jun 30, 2001 · N370E · Substantial damageNTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.Jun 27, 2001 · N5272Q · Substantial damageNTSB CHI01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Hudson, MIUnsuitable terrain for landing encountered by the pilot during the forced landing attempt. Factors relating to this accident were fuel starvation caused by foreign material blocking the fuel tank lines which led to the engine failure, annual inspection…Jun 27, 2001 · N86960 · Substantial damageNTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.Jun 26, 2001 · N4063R · Substantial damageNTSB MIA01LA171Accident · No injuriesLimited investigationFinal reportLockheed P-38L-5LD · Greenwood, MSthe failure and uncontained separation of supercharger impeller blades for undetermined reasons during normal descent, resulting in a punctured fuel line and the subsequent in-flight engine fire and emergency descent and forced landing to a farm field.Jun 25, 2001 · N25Y · Substantial damageNTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.Jun 25, 2001 · N29C · Substantial damageNTSB CHI01LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Columbia, MOThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jun 21, 2001 · N20WR · DestroyedNTSB ANC01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKA malfunction of the engine fuel control due to an improper overhaul by other maintenance personnel, and subsequent loss of engine power during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.Jun 20, 2001 · N43551 · Substantial damageNTSB MIA01LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Oak Hill, FLA partial loss of engine power while at a low altitude cruise due to fuel contamination, and the subsequent emergency descent and landing to a rural road resulting in collision with tree and mailbox post.Jun 19, 2001 · N8957L · Substantial damageNTSB ATL01LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Colquitt, GAThe student pilot's failure to use the fuel selector valve properly which resulted in fuel starvation and the subsequent loss of engine power, and the pilot's improper flare during landing.Jun 17, 2001 · N75579 · Substantial damageNTSB MIA01LA164Accident · 1 fatalLimited investigationFinal reportBroyles P51 · Conestee, SCPartial loss of engine power due to an engine cylinder experiencing detonation resulting in a forced landing to none suitable terrain.Jun 16, 2001 · N251RB · DestroyedNTSB LAX01LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · San Diego, CAthe flight crew's excessive descent rate, which resulted in an injury to a flight attendant.Jun 16, 2001 · N661AW · No damageNTSB CHI01LA173Accident · No injuriesLimited investigationFinal reportCessna 172S · Cambridge, NEthe pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…Jun 16, 2001 · N494SP · Substantial damageNTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.Jun 15, 2001 · N4734R · DestroyedNTSB LAX01FA208Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Lanai City, HIthe CFI's inadequate in-flight planning/decision making, inadequate supervision, and his delayed remedial action, which resulted in controlled flight into terrain.Jun 15, 2001 · N319FC · DestroyedNTSB NYC01LA144Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS-350-BA · Hopewell, NJthe pilot's improper decision to continue flight in instrument meteorological conditions, and which resulted in an in-flight collision with trees. Factors were the fog, and dark night conditions.Jun 14, 2001 · N555LH · Substantial damageNTSB FTW01LA143Accident · Minor injuriesLimited investigationFinal reportCommander 114-B · Okmulgee, OKthe failure of the #6 cylinder's connecting rod, which resulted in a complete loss of engine power. A contributing factor to the accident was the lack of suitable terrain for the forced landing.Jun 14, 2001 · N114BW · Substantial damageNTSB FTW01LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, TXA loss of engine power for undetermined reasons. Contributing to the accident was the collapse of the landing gear for undetermined reasons.Jun 14, 2001 · N820B · Substantial damageNTSB IAD01LA068Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Danbury, CTthe pilot's misjudged altitude and excessive airspeed resulting in a collision with a pole. A factor was the cracked exhaust stack, which resulted in a partial loss of engine power.Jun 9, 2001 · N27221 · Substantial damage