OpenAirDocs.org

NTSB investigations

1,978 cases where the phase of flight was Unknown.

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 = 990)
  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 SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.Mar 13, 1999 · N9578W · Substantial damageNTSB FTW99LA086Accident · 1 fatalLimited investigationFinal reportKeil Jaeger D-IX · Santa Fe, TXThe separation of the right upper aileron for an undetermined reason.Feb 28, 1999 · N257JK · DestroyedNTSB NYC99FA007Accident · 2 fatalField investigationFinal reportCessna 172G · Bennington, VTThe pilot's VFR flight into IMC. Contributing factors were the pilot's lack of recent experience, mountainous/hilly terrain, and clouds.Oct 12, 1998 · N1330F · DestroyedNTSB CHI99LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Muskegon, MIpoor in-flight planning by an unqualified person which resulted in fuel exhaustion. A factor was the swamp in which the forced landing was made.Oct 5, 1998 · N8655S · Substantial damageNTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.Oct 4, 1998 · N4479D · DestroyedNTSB ANC98FA168Accident · 1 fatalField investigationFinal reportCessna TU-206G · Ketchikan, AKThe pilot's continued VFR flight into instrument meteorological conditions. Contributing factors were low ceilings and mountainous/hilly terrain.Sep 29, 1998 · N4820U · DestroyedNTSB ANC98FA152Accident · 1 fatalField investigationFinal reportCessna 207 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, mountainous/hilly terrain features, rain, and fog.Sep 17, 1998 · N1809Q · DestroyedNTSB MIA98LA242Accident · No injuriesLimited investigationFinal reportCessna 177RG · Covington, GAslippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.Sep 5, 1998 · N2679V · Substantial damageNTSB ATL98FAMS1Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingThe aircraft is missing.Aug 18, 1998 · N25626 · DestroyedNTSB FTW98FA340Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Seminole, TXThe pilot's failure to maintain aircraft control.Jul 31, 1998 · N7018H · DestroyedNTSB CHI98LA368Accident · 2 fatalLimited investigationFinal reportGrumman American AA-5B · Deadwood, SDThe pilot's failure to maintain adequate clearance from the trees.Jul 26, 1998 · N4535P · DestroyedNTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.Jul 20, 1998 · N31066 · Substantial damageNTSB FTW98FA307Accident · Serious injuriesField investigationFinal reportCessna 172N · Lincoln, TXThe #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.Jul 11, 1998 · N5632E · DestroyedNTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…Jun 23, 1998 · N3853Q · DestroyedNTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…May 16, 1998 · N3230H · DestroyedNTSB ANC98FA043Accident · 1 fatalField investigationFinal reportTaylorcraft BL12 · Sitka, AKThe pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were clouds, the pilot's lack of instrument flight experience, obscuration and mountainous terrain.Apr 28, 1998 · N33902 · DestroyedNTSB ATL98FA063Accident · 2 fatalField investigationFinal reportWilliam Sargent Lancair 235 · Newport, TNThe pilot's attempt to operate in instrument meteorological conditions and his failure to maintain clearance with the surrounding terrain. Contributing factors were clouds and the mountainous/hilly terrain.Apr 17, 1998 · N813Y · DestroyedNTSB SEA98FA101Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Bigfork, MTThe pilot's failure to maintain terrain clearance for undetermined reasons. Contributing factors were the mountainous terrain, trees, dark night conditions, clouds and pilot fatigue.Apr 11, 1998 · N9247W · DestroyedNTSB ANC98GA036Accident · 2 fatalFinal reportCessna 185F · Nightmute, AKThe pilot's continued VFR flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors in the accident were meteorological conditions consisting of low ceilings, and blowing snow,…Apr 9, 1998 · N5485R · DestroyedNTSB FTW98FA167Accident · 1 fatalField investigationFinal reportBell 206B · Round Top, TXThe pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, and trees.Apr 2, 1998 · N7734A · DestroyedNTSB MIA98FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 182H · MissingUndetermined.Mar 28, 1998 · N8460S · DestroyedNTSB CHI98FA099Accident · 1 fatalField investigationFinal reportCessna T210L · Orleans, INThe pilot's attempted VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance with trees. Contributing factors were the pilot's impairment from prescription drugs, low ceilings, fog, trees, and hilly terrain.Mar 5, 1998 · N2546S · DestroyedNTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.Dec 30, 1997 · N5532H · DestroyedNTSB CHI98LA126Accident · 1 fatalLimited investigationFinal reportCessna 177 · Ft. Leonardwood, MOThe pilot's failure to maintain adequate obstacle clearance and his inadequate inflight decision which resulted in VFR flight in to instrument meteorological conditions. The pilot's overconfidence in his ability is a contributing factor.Dec 29, 1997 · N30255 · DestroyedNTSB MIA98FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech G35 · Missingundetermined.Dec 3, 1997 · N4404D · DestroyedNTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.Oct 3, 1997 · N8955D · DestroyedNTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).Sep 19, 1997 · N70747 · DestroyedNTSB CHI97FA308Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · St. Ignaces, MIThe noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.Sep 14, 1997 · N9399W · DestroyedNTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…Aug 5, 1997 · N323VA · DestroyedNTSB MIA97IA206Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-61 · Miami, FLfailure of the right main landing gear cylinder due to stress corrosion.Jul 5, 1997 · N27UA · Minor damageNTSB SEA97LA157Accident · No injuriesLimited investigationFinal reportCessna 172M · UTUndetermined.Jul 1, 1997 · N4395R · Substantial damageNTSB MIA97LA202Accident · 1 fatalLimited investigationFinal reportDFL Holdings Tango · Keystone, FLan in-flight loss of control for undetermined reasons.Jul 1, 1997 · N772T · DestroyedNTSB ANC97FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 182F · Talkeetna, AKUndetermined.Jun 29, 1997 · N3186U · DestroyedNTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.Jun 21, 1997 · N6630C · Substantial damageNTSB CHI97LA163Accident · 1 fatalLimited investigationFinal reportSiefert 5151RG · Shelbyville, INthe cause of the accident is undetermined.Jun 10, 1997 · N81728 · DestroyedNTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.Apr 21, 1997 · N242BS · DestroyedNTSB MIA97LA125Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC10-30F · Memphis, TNA stall buffet or a high speed buffet event which occurred at an undetermined time.Apr 9, 1997 · N310FE · Substantial damageNTSB LAX97FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Avalon, CAundetermined.Feb 11, 1997 · N8436X · DestroyedNTSB MIA97FA043Accident · 1 fatalField investigationFinal reportForney F-1 · Middleburg, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and an uncontrolled descent into a wooded area. Factors relating to the accident were: failure of the pilot to obtain a…Dec 22, 1996 · N7530C · DestroyedNTSB FTW97LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Alamosa, COaircraft damage for undetermined rteasons.Nov 12, 1996 · N3293Y · Substantial damageNTSB CHI97FA024Accident · 1 fatalField investigationFinal reportCessna 177B · Chancellor, SDthe pilot's attempted flight with known deficiencies in equipment, his initiating VFR flight into IMC conditions, his spatial disorientation and loss of control of the airplane. Factors were fog, dark night, and inoperative directional gyro.Nov 5, 1996 · N34994 · DestroyedNTSB SEA97FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Halsey, ORThe pilot-in-command's failure to maintain main rotor RPM, resulting in loss of control of the helicopter and collision with terrain. Factors included the pilot's lack of experience in helicopters, and interpersonal relationship problems between the pilot and…Oct 19, 1996 · N512HH · DestroyedNTSB LAX97LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAthe student pilot's impairment of judgment and performance due to alcohol, his subsequent flight into adverse weather conditions, and his failure to maintain clearance from obstructions (power lines). Factors related to the accident were: darkness, low…Oct 12, 1996 · N2501X · DestroyedNTSB CHI96LA352Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aurora, ILundetermined.Sep 17, 1996 · N966LA · Substantial damageNTSB CHI96FA334Accident · 2 fatalField investigationFinal reportThocker RV-4 · Muncie, INwas the in-flight disconnection of the horizontal and vertical stabilizer forward attachments.Sep 17, 1996 · N952JT · DestroyedNTSB NYC96FA182Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Frankford Twnsp, NJthe pilot's inadequate preflight planning/preparation by not obtaining a preflight weather briefing, his VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatial disoriented.…Sep 7, 1996 · N422FL · DestroyedNTSB CHI96FA301Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Hinckley, ILthe instructor pilot exceeded the design stress limits of the aircraft which resulted in the overload failure of the wing. A factor was that the weight and balance of the aircraft was exceeded by the instructor pilot.Aug 19, 1996 · N5026Q · DestroyedNTSB ANC96FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman G21-G · Dutch Harbor, AKUndetermined.Aug 12, 1996 · N660PA · DestroyedNTSB SEA96FA170Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Libby, MTcollision with rising mountainous terrain for unknown reason(s).Jul 26, 1996 · N3071R · DestroyedNTSB MIA96FA186Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Bch, FLthe pilot's impairment of judgment and performance because of gastroenteritis and use of the prescription drug Phenergan (promethazine).Jul 15, 1996 · N65514 · Destroyed