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 LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…Aug 2, 2005 · N4401X · DestroyedNTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Aug 2, 2005 · N5802 · Substantial damageNTSB CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.Aug 2, 2005 · N3219T · Substantial damageNTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.Jul 31, 2005 · N1003G · Substantial damageNTSB LAX05CA257Accident · Minor injuriesData collectionFinal reportCessna A150M · Trinity Center, CAthe pilot's failure to select an adequate altitude, which would assure clearance from the mountainous terrain while flying into a box canyon in high density altitude conditions.Jul 31, 2005 · N8166V · DestroyedNTSB IAD05LA112Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Mount Holly, NJThe flight instructor's delayed remedial action. A factor was the flight instructor's failure to ensure that both pilots knew who was performing the maneuver.Jul 31, 2005 · N399HF · Substantial damageNTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.Jul 30, 2005 · N8870R · Substantial damageNTSB ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.Jul 30, 2005 · N3188C · DestroyedNTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.Jul 28, 2005 · N6776E · Substantial damageNTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.Jul 28, 2005 · N602EA · DestroyedNTSB ANC05LA110Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Ketchikan, AKAn electrical arc on the exterior of a fuel pressure line that initiated a fuel leak and fire during cruise flight, which resulted in serious injuries to the pilot as he performed an emergency landing on the water. A factor contributing to the accident was an…Jul 28, 2005 · N6868B · Minor damageNTSB DFW05CA198Accident · Minor injuriesData collectionFinal reportAmateur Built Varieze · Alco, ARThe pilot's pilots failure to refuel the airplane. Contributing factors were the low ceilings and the lack of suitable terrain for the precautionary landing.Jul 27, 2005 · N115JT · Substantial damageNTSB MIA05LA136Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2B · Ft. Pierce, FLThe pilot's inadequate preflight planning/preparation, and failure to refuel the helicopter prior to takeoff which resulted in fuel exhaustion and a loss of engine power during the landing.Jul 24, 2005 · N9023M · Substantial damageNTSB LAX05LA242Accident · 1 fatalLimited investigationFinal reportQuicksilver Mxlii 101 Sport · Galt, CAloss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and uncontrolled descent into terrain.Jul 20, 2005 · UNREG · DestroyedNTSB IAD05LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Copake, NYThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.Jul 20, 2005 · N7767N · Substantial damageNTSB IAD05LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Denton, MDA loss of engine power for undetermined reasons.Jul 18, 2005 · N4797L · Substantial damageNTSB DFW05LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pollock, LAThe loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.Jul 16, 2005 · N33720 · Substantial damageNTSB CHI05LA190Accident · No injuriesLimited investigationFinal reportMooney M20M · White Cloud, MIA loss of engine power during cruise flight due to the mechanic's improper maintenance, the disconnected oil line, the oil leak from the disconnected line, and the unsuitable terrain the pilot encountered during the forced landing. Factors were the outside…Jul 15, 2005 · N355RZ · Substantial damageNTSB CHI05CA185Accident · Minor injuriesData collectionFinal reportAero Commander S2R · Walnut, ILFuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.Jul 14, 2005 · N8962Q · Substantial damageNTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.Jul 13, 2005 · N30SP · Substantial damageNTSB LAX05FA229Accident · No injuriesField investigationFinal reportEurocopter AS350BA · Kapaau, HIthe in-flight separation of the tail rotor system as a result of a loss of clamp force and fatigue fracturing of the attachment nut plates. The cause of the loss of clamp force was likely due to an inadvertent tail rotor blade strike during the previous…Jul 12, 2005 · N4064F · Substantial damageNTSB IAD05LA101Accident · No injuriesLimited investigationFinal reportAeronca 65CA · Cadiz, OHCarburetor icing, which resulted in a partial loss of engine power. A factor was an unanticipated hill in the forced landing rollout area.Jul 11, 2005 · N36806 · Substantial damageNTSB DCA05MA083Accident · Serious injuriesMajor investigationFinal reportBoeing 767-232 · Raleigh-Durham, NCAn inadvertent in-flight encounter with clear air turbulence.Jul 11, 2005 · N113DA · No damageNTSB ATL05FA128Accident · 1 fatalField investigationFinal reportCessna 172N · Penrose, NCA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.Jul 10, 2005 · N73747 · DestroyedNTSB CHI05LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · La Gygne, KSThe failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.Jul 9, 2005 · N4933U · Substantial damageNTSB LAX05TA226Accident · Minor injuriesFinal reportAyres S2R-G10 · Wickenburg, AZthe partial loss of engine power for undetermined reasons.Jul 7, 2005 · N440AT · Substantial damageNTSB IAD05LA096Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cape May, NJA partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.Jul 5, 2005 · N6289Z · Substantial damageNTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.Jul 5, 2005 · N6061L · Substantial damageNTSB IAD05CA092Accident · No injuriesData collectionFinal reportCallahan Rotorway Exec 90 · Weston, WVA loss of engine power for undetermined reasons during an attempted power recovery. A factor in the accident was the pilot's failure to maintain rotor rpm, which resulted in a hard landing and subsequent post crash fire.Jul 4, 2005 · N4359N · DestroyedNTSB ATL05CA122Accident · Serious injuriesData collectionFinal reportAeronca C3 · Summerville, SCThe maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.Jul 4, 2005 · N14532 · Substantial damageNTSB MIA05FA130Accident · 1 fatalField investigationFinal reportBeech V35 · De Funiak Sprgs, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and an in-flight collision with tress and terrain.Jul 3, 2005 · N2056W · Substantial damageNTSB ANC05CA095Accident · No injuriesData collectionFinal reportCessna 207 · Bethel, AKAn in-flight collision with a bird during cruise flight, which resulted in structural damage to the airplane's wing.Jul 3, 2005 · N48CF · Substantial damageNTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…Jul 2, 2005 · N686T · DestroyedNTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.Jul 2, 2005 · N795JL · Substantial damageNTSB LAX05LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Honolulu, HIthe flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…Jul 1, 2005 · N3369P · Substantial damageNTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.Jul 1, 2005 · N997SA · Substantial damageNTSB ANC05FA090Accident · 3 fatalField investigationFinal reportCessna T207 · Nanwalek, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.Jul 1, 2005 · N1621U · DestroyedNTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.Jun 30, 2005 · N3452L · Substantial damageNTSB MIA05CA125Accident · No injuriesData collectionFinal reportCessna 152 · Williston, FLThe inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.Jun 30, 2005 · N5372L · Substantial damageNTSB ATL05LA117Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Mocksville, NCThe loss of engine power due to fuel system contamination. A factor was trees.Jun 29, 2005 · N38341 · Substantial damageNTSB ATL05LA115Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Rome, GAThe pilot's delay in the use of carburetor heat, which resulted in the formation of carburetor / induction ice and the loss of engine power.Jun 27, 2005 · N70847 · Substantial damageNTSB IAD05LA085Accident · 1 fatalLimited investigationFinal reportMartel Air Command 532Elite · Highgate, VTThe pilot's improper cyclic input, which resulted in a retreating rotor blade stall, and its subsequent impact with the propeller. Also causal, was the pilot's failure to acquire proper training. A factor was the pilot's decision not to have a stability…Jun 26, 2005 · UNREG · Substantial damageNTSB CHI05CA181Accident · Minor injuriesData collectionFinal reportPiper PA-31-310 · Lake Huron, MIThe fuel exhaustion during cruise flight, the inadequate in-flight planning/decision by the pilot, and the unsuitable terrain encountered by the pilot during the forced landing.Jun 26, 2005 · N601RE · Substantial damageNTSB CHI05CA166Accident · Minor injuriesData collectionFinal reportCessna 182F · Lapeer, MIThe pilot's inadequate preflight inspection due to his failure to physically verify the security of the fuel tank caps, the unsecured fuel tank cap and fuel exhaustion.Jun 26, 2005 · N3184U · Substantial damageNTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.Jun 25, 2005 · N2153G · Substantial damageNTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.Jun 25, 2005 · N2484T · Substantial damageNTSB SEA05LA126Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mountain Home, IDThe pilot's inadequate in-flight decision by failing to refuel resulting in fuel exhaustion during cruise flight and the loss of engine power. A vehicle was a factor in the on ground collision.Jun 24, 2005 · N4865X · Substantial damageNTSB DEN05LA099Accident · No injuriesLimited investigationFinal reportCampbell Long EZ · Santa Fe, NMthe inflight collision with a bird(s).Jun 24, 2005 · N84RW · Substantial damageNTSB ATL05LA113Accident · 1 fatalLimited investigationFinal reportMize Donald Kolb MK III X · Dickson, TNThe pilot's failure to maintain adequate obstacle clearance during climb out which resulted in the in-flight collision with a tree.Jun 24, 2005 · N194DM · Substantial damageNTSB DFW05LA167Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Carizzo Springs, TXThe failure of the stabilator trim control rod due to internal corrosion. A contributing factor was the lack of suitable terrain for the forced landing.Jun 21, 2005 · N2521M · Substantial damage