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 ANC03FA066Accident · 5 fatalField investigationFinal reportCessna 421C · Sitka, AKThe pilot's failure to follow IFR procedures by not following the published approach procedures, which resulted in an in-flight collision with terrain. Factors contributing to the accident were a low ceiling, and the pressure induced by conditions/events (the…Jul 4, 2003 · N777DX · DestroyedNTSB SEA03LA202Accident · No injuriesLimited investigationFinal reportNorth American P-51D · Jerome, IDThe malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…Jul 3, 2003 · N2869D · Substantial damageNTSB ATL03LA117Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Hendersonville, TNThe total loss of engine power due to loss of oil pressure for undetermined reasons, resulting in a forced landing and nose over on none suitable terrain.Jul 3, 2003 · N6088M · Substantial damageNTSB CHI03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Winamac, INA loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.Jul 2, 2003 · N6315P · Substantial damageNTSB MIA03LA139Accident · Serious injuriesLimited investigationFinal reportSamual G. DaSilva Velocity · Sebastian, FLThe improper repair of the crankshaft by a FAA Certified Repair Station resulting in fatigue failure and subsequent total loss of engine power. A factor in the accident was the rough/uneven terrain encountered by the pilot during the landing roll in a field.Jul 1, 2003 · N51576 · Substantial damageNTSB SEA03FA121Accident · 1 fatalField investigationFinal reportLamb RV-4 · Vail, WAA loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…Jun 29, 2003 · N6596X · Substantial damageNTSB NYC03LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172K · White Marsh, MDThe pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.Jun 29, 2003 · N5138G · Substantial damageNTSB LAX03LA216Accident · Serious injuriesLimited investigationFinal reportCessna 210D · Carefree, AZfuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.Jun 29, 2003 · N3826Y · Substantial damageNTSB CHI03LA211Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Marceline, MOThe pilot's failure to assure an adequate fuel supply which resulted in fuel exhaustion. A factor associated with the accident was the pilot's lack of experience in this make/model of aircraft.Jun 29, 2003 · UNREG · Substantial damageNTSB IAD03CA060Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Atlantic City, NJThe pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.Jun 28, 2003 · N4133Y · Substantial damageNTSB CHI03LA184Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Sandusky, MIThe failure of the ignition switch leading to an engine power loss in cruise flight and the subsequent high flare during autorotation. Factors contributing to the accident were the pilot's misjudgment of the landing flare and the unsuitable terrain…Jun 28, 2003 · N8413D · Substantial damageNTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.Jun 27, 2003 · N8953M · DestroyedNTSB LAX03LA211Accident · No injuriesLimited investigationFinal reportPieterse Kitfox 2 · Corona, CAThe improper design and installation of the airplane's fuel system by the builder of the experimental airplane, which resulted in fuel starvation and a loss of engine power.Jun 26, 2003 · N164JR · Substantial damageNTSB CHI03FA179Accident · 1 fatalField investigationFinal reportEurocopter EC120B · Boonville, MOThe pilot's inadequate weather evaluation which resulted in his inadvertent flight into instrument meteorological conditions. An additional cause was the pilot's failure to maintain clearance from the terrain. The dark night, thunderstorms, rain and lack of…Jun 26, 2003 · N298HS · DestroyedNTSB SEA03TA116Accident · Minor injuriesFinal reportMcDonnell Douglas 369E · Big Timber, MTFretting on the outside diameter of the compressor coupling adapter which resulted in fatigue and subsequent fracture of the adapter, and ultimately the disconnection of the compressor from the turbine assembly. Contributing factors were low rotor RPM, uneven…Jun 25, 2003 · N1502 · Substantial damageNTSB MIA03LA134Accident · Serious injuriesLimited investigationFinal reportJohn L. Klein Marquart ChargerMA-5 · Pierson, FLSeparation of the elevator push/pull tube from the rear cockpit's control stick for undetermined reasons, which resulted in a loss of elevator control, an uncontrolled descent, and an impact with trees.Jun 25, 2003 · N707JK · Substantial damageNTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…Jun 25, 2003 · N7512P · DestroyedNTSB ANC03FA061Accident · 2 fatalField investigationFinal reportCessna 172 · Skagway, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Factors associated with the accident were low ceilings, rain, and fog.Jun 25, 2003 · N736QK · Substantial damageNTSB DEN03LA110Accident · No injuriesLimited investigationFinal reportAlexander Schleicher · Paragonah, UTThe pilot's encounter with unsuitable terrain during a precautionary landing. Contributing factors were the strong winds and the approaching vehicle.Jun 24, 2003 · D-KIMK · Substantial damageNTSB SEA03LA117Accident · No injuriesLimited investigationFinal reportCessna T337D · Driggs, IDThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor contributing to the accident was the unsuitable terrain for the forced landing.Jun 22, 2003 · N86182 · Substantial damageNTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.Jun 22, 2003 · N8762T · Substantial damageNTSB IAD03CA062Accident · No injuriesData collectionFinal reportWilliam Stevens RAF2000 · Stoutsville, OHSeparation of the engine computer wire and connector, which resulted in a partial loss of engine power.Jun 22, 2003 · N186S · Substantial damageNTSB ATL03LA112Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW28 · Batesburg, SCThe loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.Jun 21, 2003 · N128ED · Substantial damageNTSB CHI03LA170Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Covert, MIFailure of the pilot to verify fuel quantity prior to the accident flight, and fuel exhaustion resulting in a loss of engine power. Contributing factors were the soft, rough, unsuitable terrain for a forced landing.Jun 20, 2003 · N3659T · Substantial damageNTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.Jun 19, 2003 · N270LM · Substantial damageNTSB MIA03LA127Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Taylor, FLThe in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.Jun 18, 2003 · N294SK · No damageNTSB MIA03FA124Accident · 5 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FL**This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…Jun 17, 2003 · N4903F · 2 aircraft · DestroyedNTSB MIA03CA129Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kissimmee, FLThe inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…Jun 16, 2003 · N7185K · Substantial damageNTSB 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.Jun 16, 2003 · N721PT · Substantial damageNTSB LAX03FA200Accident · 4 fatalField investigationFinal reportMcDonnell Douglas 369D · Volcano, HIa loss of engine power due to the fatigue fracture and separation of the compressor coupling adapter. The fatigue fracture was initiated by fretting on the pilot diameter due to both the inadequate design of the coupling and the coaxial misalignment of the…Jun 15, 2003 · N4493M · DestroyedNTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…Jun 15, 2003 · N34LB · Substantial damageNTSB DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.Jun 15, 2003 · N4031Z · DestroyedNTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.Jun 14, 2003 · N601G · Substantial damageNTSB LAX03IA199Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZthe simultaneous failure of both horizontal stabilizer trim channels on two separate occasions for undetermined reasons.Jun 14, 2003 · N97325 · No damageNTSB DEN03LA107Accident · No injuriesLimited investigationFinal reportBeech S35 · Colorado Spring, COthe pilot's inadequate in-flight planning/decision in which he mismanaged his fuel supply by failing to switch tanks resulting in fuel starvation and the loss of engine power. A contributing factor was the pilot's diverted attention.Jun 14, 2003 · N5751K · Substantial damageNTSB CHI03LA165Accident · No injuriesLimited investigationFinal reportEngineering & Research 415-C · Independence, KSA loss of engine power due to fuel starvation. A factor to the accident was the pilot's improper installation of the fuel cap.Jun 14, 2003 · N87198 · Substantial damageNTSB ATL03FA125Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Dover, TNThe pilot continued VFR flight into adverse weather conditions including instrument meteorological conditions and turbulence in thunderstorms, which resulted in a loss of control in flight and subsequent collision with terrain.Jun 14, 2003 · N68551 · Substantial damageNTSB DEN03LA153Accident · Minor injuriesLimited investigationFinal reportSharp Corben Baby Ace D · Wamsutter, WYA loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing.Jun 13, 2003 · N794CH · Substantial damageNTSB DEN03LA152Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Santa Fe, NMthe inadvertent encounter with turbulence associated with thunderstorms. A contributing factor was the icing conditions.Jun 13, 2003 · N211EZ · Substantial damageNTSB CHI03LA159Accident · No injuriesLimited investigationFinal reportCessna T210N · Tribune, KSThe in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.Jun 13, 2003 · N210MP · Substantial damageNTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…Jun 12, 2003 · N6981Z · Substantial damageNTSB MIA03FA122Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Carthage, MSThe failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…Jun 12, 2003 · N232HC · DestroyedNTSB LAX03LA193Accident · Serious injuriesLimited investigationFinal reportBoeing MD-82 · Fort Worth, TXThe encounter with severe turbulence during descent, prior to the cabin crew taking their seats, which resulted in serious injury to two flight attendants.Jun 12, 2003 · N451AA · No damageNTSB ATL03LA152Accident · 2 fatalLimited investigationFinal reportChinook Plus 2 A13-SWB · Elsanor, ALThe loss of engine power for undetermined reasons.Jun 12, 2003 · UNREG · Substantial damageNTSB NYC03LA127Accident · Minor injuriesLimited investigationFinal reportCessna 172H · East Vincent, PAThe pilot's inadequate in-flight planning/preparation which resulted in fuel exhaustion during cruise flight. The pilot's inadequate preflight preparation in which he failed to refuel the airplane is a contributing factor.Jun 11, 2003 · N3027U · Substantial damageNTSB LAX03LA190Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVThe pilot's inadequate preflight and his mismanagement of the fuel supply by his failure to switch fuel tanks.Jun 10, 2003 · N5058P · Substantial damageNTSB DEN03IA101Incident · Minor injuriesIncident investigationFinal reportBoeing 757-200 · Dodge City, KSthe inadvertent activation of the flight deck door's upper pressure relief latch during closure of the door, resulting in the deployment of the upper decompression panel which subsequently struck the captain. Contributing factors included the operator's…Jun 10, 2003 · N704X · No damageNTSB LAX03FA187Accident · 1 fatalField investigationFinal reportRockwell International Aero-Commander 112TC · Santa Nella, CAThe pilot's inadequate in-flight planning/decision by conducting VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were low clouds, fog, and mountainous terrain.Jun 9, 2003 · N4696W · DestroyedNTSB CHI03LA155Accident · No injuriesLimited investigationFinal reportSesin EXEC90 · Searcy, ARThe unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.Jun 8, 2003 · N8246J · Substantial damageNTSB SEA03LA107Accident · No injuriesLimited investigationFinal reportPippert Zenith Air CH 701 · Rochester, WALoose jet in the carburetor while on climb out resulting in a loss of engine power.Jun 7, 2003 · N2748 · Substantial damage