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 IAD00LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172G · North Elba, NYthe pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.Jul 8, 2000 · N4198L · Substantial damageNTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…Jul 8, 2000 · N402NA · Substantial damageNTSB CHI00FA185Accident · 3 fatalField investigationFinal reportPiper PA-30 · Duluth, MNloss of control in flight for undetermined reason(s).Jul 8, 2000 · N7213Y · DestroyedNTSB LAX00LA258Accident · No injuriesLimited investigationFinal reportCessna 205 · Tacna, AZThe piston and rings in cylinder No. 1 failed resulting in a total loss of engine power. The pilot made a forced landing on a road and the airplane's wing collided with a road sign.Jul 5, 2000 · N8154Z · Substantial damageNTSB LAX00LA250Accident · Serious injuriesLimited investigationFinal reportThorp T211 · Grass Valley, CAthe pilot encountered a mountain wave at an altitude too low to maintain clearance from trees.Jul 4, 2000 · N91313 · Substantial damageNTSB CHI00LA188Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20L · Gregory, MIthe control stick movement being restricted by the pilot's seat-type parachute and the excessive descent rate and airspeed during landing. A factor to the accident was the pilot's lack of familiarity with the aircraft.Jul 4, 2000 · N4804W · Substantial damageNTSB ANC00FA082Accident · 1 fatalField investigationFinal reportCessna 172S · Whittier, AKSuicide.Jul 4, 2000 · N862SP · DestroyedNTSB MIA00LA196Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Selma, ALThe improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…Jul 3, 2000 · N26937 · Substantial damageNTSB SEA00LA121Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · West Linn, ORImproper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…Jul 2, 2000 · N2784D · Substantial damageNTSB MIA00TA200Accident · No injuriesFinal reportHughes 369D · Destin, FLimproper maintenance inspection of the tail rotor by maintenance personnel and improper preflight inspection of the tail rotor by the pilot, which resulted in worn elastomeric bearings being continued in service, resulting in failure of the tail rotor…Jul 2, 2000 · N88MP · Substantial damageNTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.Jul 2, 2000 · N757SL · DestroyedNTSB MIA00LA204Accident · No injuriesLimited investigationFinal reportSpurgeon Avid Bandit · Columbus, MSthe owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.Jul 1, 2000 · N60698 · Substantial damageNTSB DEN00IA133Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries 20C-1 · Spanish Fork, UTThe company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.Jul 1, 2000 · N991CT · Minor damageNTSB CHI00LA179Accident · 1 fatalLimited investigationFinal reportNorton Volksplane VP-1 · Waconia, MNthe inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.Jul 1, 2000 · N256DN · DestroyedNTSB SEA00LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kennewick, WAA failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…Jun 30, 2000 · N6887W · Substantial damageNTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…Jun 30, 2000 · N8787V · Substantial damageNTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.Jun 30, 2000 · N7037E · Substantial damageNTSB CHI00LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Saint Vincent, MNthe failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.Jun 30, 2000 · N11A · Substantial damageNTSB LAX00LA245Accident · 1 fatalLimited investigationFinal reportGarlick HH-1K · Live Oak, CAThe inadequate lubrication of the tail rotor drive shaft coupling by unknown maintenance personnel that resulted in the in-flight failure and separation of the helicopter's tail boom.Jun 29, 2000 · N896RP · DestroyedNTSB LAX00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Mayer, AZthe total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.Jun 29, 2000 · N3094Q · Substantial damageNTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.Jun 29, 2000 · N780CA · Substantial damageNTSB DEN00FA119Accident · 2 fatalField investigationFinal reportCessna 172H · Angel Fire, NMThe pilot's improper inflight decision to prematurely attempt a climb towards rising terrain before sufficient altitude had been attained that would assure adequate obstacle clearance. Factors were high density altitude and trees.Jun 26, 2000 · N2526L · DestroyedNTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.Jun 25, 2000 · N3396S · DestroyedNTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.Jun 24, 2000 · N8629Y · Substantial damageNTSB ATL00LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Loss of engine power for undetermined reasons. A factor was the pilot failed to use carburetor heat during the descent.Jun 24, 2000 · N738WD · Substantial damageNTSB NYC00LA174Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Springdale, OHThe pilot's inadequate preflight of the helicopter, and his subsequent failure to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain.Jun 23, 2000 · N383MA · Substantial damageNTSB MIA00FA190Accident · 4 fatalField investigationFinal reportLearjet 55 · Boca Raton, FLThe failure of the pilot's of both airplanes to maintain a visual lookout (while climbing and maneuvering) resulting in an in-flight collision and subsequent collision with residences and terrain.Jun 23, 2000 · N220JC · 2 aircraft · DestroyedNTSB LAX00LA260Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Ana, CAThe loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.Jun 22, 2000 · N7598D · Substantial damageNTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.Jun 21, 2000 · N4119Q · Substantial damageNTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…Jun 21, 2000 · N704QJ · Substantial damageNTSB ANC00LA073Accident · Minor injuriesLimited investigationFinal reportBlanc Glastar · Northway, AKThe pilot's continued flight into known adverse weather. A factor associated with the accident were low clouds.Jun 21, 2000 · N2623B · DestroyedNTSB LAX00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Selma, CAThe pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.Jun 20, 2000 · N32322 · Substantial damageNTSB ANC00GA071Accident · 4 fatalFinal reportCessna 185E · Talkeetna, AKThe pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…Jun 20, 2000 · N1589F · DestroyedNTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.Jun 19, 2000 · N94290 · Substantial damageNTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.Jun 17, 2000 · N831AL · No damageNTSB DEN00LA113Accident · Minor injuriesLimited investigationFinal reportEnstrom 280CB · Ruidoso, NMthe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight planning. A contributing factor was the pilot's lack of experience in the model of helicopter.Jun 17, 2000 · N440RB · Substantial damageNTSB NYC00LA164Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Louisville, KYThe pilot's improper operation of the fuel selector.Jun 16, 2000 · N485CA · Substantial damageNTSB IAD00LA052Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Mansfield, NJThe pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.Jun 16, 2000 · N9014N · Substantial damageNTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.Jun 14, 2000 · N67608 · Substantial damageNTSB FTW00LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Helena, ARThe pilot's failure to maintain clearance with the power lines.Jun 13, 2000 · N3096Z · DestroyedNTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.Jun 11, 2000 · N66081 · DestroyedNTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…Jun 9, 2000 · N8321S · Substantial damageNTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.Jun 9, 2000 · N914AE · Minor damageNTSB CHI00LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe improper in-flight decision of the pilot not to land at the nearest airport at the first loss of engine power. Factors to the accident were fuel exhaustion, the excessive fuel flow, and the airport perimeter fence.Jun 9, 2000 · N4142F · Substantial damageNTSB ATL00LA062Accident · Serious injuriesLimited investigationFinal reportDaniel J. Zoerb Kitfox · Spruce Pine, NCA total loss of engine power due to carburetor icing conditions. A factor was the mountainous, unsuitable terrain on which to make a forced landing.Jun 9, 2000 · N715DZ · Substantial damageNTSB ANC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's improper positioning of the fuel tank selector, and fuel starvation. A factor in the accident was the improper service of the airplane's hydraulic brake system.Jun 9, 2000 · N9739P · Substantial damageNTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…Jun 8, 2000 · N31M · Substantial damageNTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.Jun 8, 2000 · N9407W · Substantial damageNTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.Jun 8, 2000 · N493K · Substantial damageNTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.Jun 7, 2000 · N39827 · Substantial damage