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 DCA90IA048Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe pilot(s) allowed the aircraft to rotate to an excessive nose high attitude, either during a takeoff or landing.Aug 10, 1990 · N306US · Minor damageNTSB CHI90DEM08Accident · 2 fatalFinal reportCessna 150L · Holland, MIUndetermined. Factors related to the accident were: darkness & impairment of the pilot due to carbon monoxide.Aug 7, 1990 · N741MF · DestroyedNTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.Aug 4, 1990 · N45238 · Substantial damageNTSB SEA90FA146Accident · 3 fatalField investigationFinal reportWheeler Technology FT-210 · Linch, WYFailure of the pilot to maintain control of the aircraft and/or correct the stall/spin.Jul 25, 1990 · N210EX · DestroyedNTSB CHI90FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Marais, MNPoor judgement of the pilot due to his impairment from consumption of alcohol, and his failure to maintain control of the aircraft. A factor related to the accident was: pilot fatigue due to lack of sleep.Jul 14, 1990 · N6146W · DestroyedNTSB LAX90FA211Accident · 1 fatalField investigationFinal reportBeech 35-33 · Paso Robles, CAUndetermined.Jun 8, 1990 · N996T · DestroyedNTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.Jun 7, 1990 · N50353 · DestroyedNTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).May 12, 1990 · N7SF · DestroyedNTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.Apr 20, 1990 · N8333Y · DestroyedNTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.Apr 18, 1990 · N91309 · DestroyedNTSB MIA90LA061Accident · 2 fatalLimited investigationFinal reportCessna 152 · Missing, FLUndetermined.Jan 24, 1990 · N4802B · DestroyedNTSB SEA90FA036Accident · 2 fatalField investigationFinal reportPiper PA-18 · Longmire, WAUndetermined.Jan 20, 1990 · N7216K · DestroyedNTSB MIA90FA060Accident · 2 fatalField investigationFinal reportPiper J-3 · Clewiston, FLFailure of the pilot to secure the flight control stick (inadequate preflight) before takeoff.Jan 20, 1990 · N88125 · DestroyedNTSB MIA90LA053Accident · No injuriesLimited investigationFinal reportBeech E185 · Wauchula, FLLoss of air pressure in the left main tire during flight, which resulted in a ground swerve during the landing and a nose over as the pilot was correcting with opposite brake and rudder.Jan 13, 1990 · N50BP · Substantial damageNTSB DEN90FA041Accident · 3 fatalField investigationFinal reportCessna 182P · Tom'S Place, CAContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above the ground. Factors related to the accident were: dark night, adverse weather conditions, self induced pressure, and spatial…Jan 13, 1990 · N5831J · DestroyedNTSB CHI90IA064Incident · No injuriesIncident investigationFinal reportBoeing 747-151 · Detroit, MIA fire in the aft cargo compartment for undetermined reasons(s).Jan 10, 1990 · N602US · Minor damageNTSB CHI90LA280Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Engadine, MIA collision with trees and the terrain for undetermined reasons.Dec 2, 1989 · N2440P · Substantial damageNTSB FTW90GA040Accident · Serious injuriesFinal reportAerospatiale AS-350B · Liberty Hill, TXUndetermined.Nov 30, 1989 · N5804T · DestroyedNTSB DCA90MA010Accident · 8 fatalMajor investigationFinal reportBritten-Norman BN-2 · Block Island, RIThe aircraft crashed for an undetermined reason, during an overwater flight on a dark (moonless) night under a cloud layer. A SIGMET was in effect warning of moderate to occasionally severe turbulence below 6000 feet and the potential of low level wind shear.Nov 28, 1989 · N127JL · DestroyedNTSB CHI90LA032Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Howell, MIFailure of the mixture control cable, which resulted in a loss of power due to fuel starvation during a climb after takeoff. A factor related to the accident was: rough terrain in the emergency landing area.Nov 23, 1989 · N819CM · Substantial damageNTSB LAX90LAMS1Accident · 1 fatalFinal reportCessna U206E · Pacific Ocean (Pacific Ocean)Undetermined.Nov 17, 1989 · N9423G · DestroyedNTSB SEA90FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech 36TC · MissingUndetermined until the airplane is located.Oct 6, 1989 · N6773C · DestroyedNTSB SEA89LA179Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Mackay, IDThe pilot failed to maintain an adequate airspeed for flight. High density altitude was a factor.Sep 24, 1989 · N71756 · Substantial damageNTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.Sep 1, 1989 · N62JE · DestroyedNTSB ANC89FA144Accident · 2 fatalField investigationFinal reportPiper PA-12 · Windy Fork, AKFailure of the pilot to maintain airspeed while operating to or from the gravel bar, which resulted in an inadvertent stall. The rising terrain was considered a contributing factor.Aug 13, 1989 · N7542H · DestroyedNTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.Aug 12, 1989 · N1211V · DestroyedNTSB MIA89FA214Accident · 1 fatalField investigationFinal reportCessna 210L · Marco, FLContinued VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudgment of altitude and his physical impairment from use of drugs. Contributing factors were: the pilot's probable spatial disorientation, and the night/weather…Aug 5, 1989 · N2676S · DestroyedNTSB SEA89LA134Accident · No injuriesLimited investigationFinal reportMirsepasy 3Q2 · Arlington, WAFuel starvation due to a blocked fuel line which resulted in the pilot having to land on unsuitable terrain.Jul 18, 1989 · N38AM · Substantial damageNTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.Jun 21, 1989 · N30BS · DestroyedNTSB SEA89FA099Accident · 2 fatalField investigationFinal reportCushing 4 · Mansfield, WAFailure of the left wing main spar due to overload for undetermined reasons.Jun 4, 1989 · N5321U · DestroyedNTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.Apr 7, 1989 · N9473L · DestroyedNTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.Mar 17, 1989 · N80542 · DestroyedNTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…Mar 16, 1989 · N5403D · Substantial damageNTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.Mar 6, 1989 · N24236 · DestroyedNTSB MKC89FA061Accident · 2 fatalField investigationFinal reportBeech 58 · Hamburg, ARThe pilot continued VFR flight into IMC conditions and failed to maintain sufficient altitude above the wooded terrain. Weather conditions, low light conditions at or near dusk, lack of visual cues (visual perception) by the pilot, and trees were contributing…Feb 17, 1989 · N348U · DestroyedNTSB MIA89LAMS1Accident · 1 fatalFinal reportPiper PA-28-151 · Missing Acft (Atlantic Ocean)The pilot's decision to commit suicide. Contributing to the accident was the pilot's interpersonal relations and his psychological condition.Feb 6, 1989 · N6834J · DestroyedNTSB DCA89LA012Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2J · Missing (Pacific Ocean)During a flt at night from majuro, marshall islands to cairns, australia, the plt requested a dscnt from FL 190 to 12,000 to remove ice from the airframe. Later, he requested a climb to FL 200. After starting the climb, he made a mayday call to sidney flt…Dec 9, 1988 · N296MA · DestroyedNTSB CHI89FA030Accident · 2 fatalField investigationFinal reportMooney M20J · Vermillion, ILDec 3, 1988 · N201UL · DestroyedNTSB LAX89LA054Accident · No injuriesLimited investigationFinal reportCessna 175 · Tracy, CAThe airplane was found nosed over and abandoned short of the airport. The owner of the airplane was identified as the pilot, however, he does not hold a pilots license nor a medical certificate. Inspection of the airplane revealed that the fuel tanks were…Nov 20, 1988 · N6641E · Substantial damageNTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…Nov 17, 1988 · N1963P · DestroyedNTSB LAX89LA028Accident · 1 fatalLimited investigationFinal reportRobinson R22 · Lower Lake, CADuring a local solo instructional flight, the helicopter collided with the terrain in an open field aprx 3 miles from the airport. It was reported to have contacted the ground at considerable downward speed with high rotor RPM. No preimpact mechanical failure…Oct 30, 1988 · N2627K · DestroyedNTSB NYC89DHM03Accident · 1 fatalFinal reportVangorden KR-2 · Allaire, NJThe homebuilt aircraft was being flown on its maiden flight when the accident occurred. A witness stated that he observed the aircraft 'swirling down like a bird with a broken wing.' According to him, the aircraft was intact with no evidence of smoke before…Oct 12, 1988 · N3774G · DestroyedNTSB SEA88LA188Accident · 2 fatalLimited investigationFinal reportSvensson Bushby Mustang II · Everett, WAJust prior to the acdnt, witnesses saw the acft in a steep, high speed descent. Impact occurred in soft, marshy terrain & much of the wreckage was buried. No mechanical reason was found for a loss of control; however, the acft was extensively damaged drg…Sep 24, 1988 · N7SV · DestroyedNTSB NYC88DHA04Accident · 1 fatalFinal reportBanks/Mong Sport · Marshalls Creek, PAThe homebuilt airplane impacted the ground in a steep nose down attitude among three tall pine trees. After impact, it bounced back about three feet & came to rest. There was no damage to the trees. An exam of the prop revealed no evidence of the engine…Sep 8, 1988 · N25JJ · Substantial damageNTSB LAX88FAMS3Accident · 3 fatalMissing aircraftFinal reportCessna 172P · Kauai, HIThe pilot departed for honolulu, HI after flying for 3 hours, 45 minutes without refueling. The flight to honolulu takes 1 hour. The airplane has a full fuel endurance of four hours. It disappeared from navy radar 25 miles southeast of Kauai. Acft wreckage…Sep 3, 1988 · N51886 · DestroyedNTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…Aug 24, 1988 · N5626F · DestroyedNTSB MIA88FA254Accident · 1 fatalField investigationFinal reportCessna 172E · Floweree, MSThe student pilot departed early in the morning and was not found until the next afternoon. There were no witnesses to the accident. The aircraft impacted the ground in a 50 degree nose down angle at a high rate of speed with evidence of aircraft rotation…Aug 13, 1988 · N5555T · DestroyedNTSB CHI88FA190Accident · 2 fatalField investigationFinal reportMcdonnell Douglas 269B · Braceville, ILConducting maneuvering flight the PIC failed to monitor the helicopter systems and allowed the main rotor RPM to decay to the point where it would not produce enough lift to sustain flight.Aug 2, 1988 · N9522F · DestroyedNTSB MIA88FA232Accident · 1 fatalField investigationFinal reportRockwell S2R · O'Brien, FLThe purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck…Jul 24, 1988 · N4222X · DestroyedNTSB DEN88LA162Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Teresa, NMAn unknown person or persons took a Cessna 177RG from a small airport near the mexican border, without permission. State police found it crashed in a field 2 miles southwest of Santa Teresa airport, and notified the owner. No witnesses have been found to…Jul 17, 1988 · N34338 · Substantial damage