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 LAX98LA293Accident · Serious injuriesLimited investigationFinal reportPZL-Bielsko SZD-59 · Truckee, CAThe failure of the pilot to maintain sufficient airspeed which resulted in a inadvertent stall/spin.Sep 14, 1998 · N59SE · DestroyedNTSB FTW98FA394Accident · 2 fatalField investigationFinal reportGrumman American AA-1B · Yoder, COThe pilot's loss of aircraft control due to not maintaining adequate airspeed and the subsequent inadvertent stall. Factors were the pilot's inadequate preflight and the engine's power failure due to fuel exhaustion.Sep 12, 1998 · N6288L · DestroyedNTSB ATL98LA124Accident · No injuriesLimited investigationFinal reportCessna 150E · Bradenton, FLThe loss of engine power for undetermined reasons.Sep 12, 1998 · N6080T · Substantial damageNTSB FTW98LA396Accident · Serious injuriesLimited investigationFinal reportDempsey Skybolt TD8 · Dundee, TXHard landing due to the pilot's improper landing flare. Factor were the fuel exhaustion due to the pilot's failure to refuel, and his lack of familiarity with the airplane.Sep 11, 1998 · N350TD · Substantial damageNTSB CHI98LA338Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Int'L Falls, MNinaccurate preflight planning which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. A factor associated with the accident was the tree which the airplane contacted during the forced landing.Sep 11, 1998 · N7965W · Substantial damageNTSB ANC98FA145Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors associated with this accident were the pilot's unfamiliarity with the geographic area, the low clouds, his becoming disoriented, and the blind canyon into which…Sep 9, 1998 · N1433Z · Substantial damageNTSB LAX98LA277Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8E · Mojave, CAFuel exhaustion due to the pilot's inadequate preflight.Sep 8, 1998 · N1716K · Substantial damageNTSB NYC98FA180Accident · 5 fatalField investigationFinal reportBeech A23-24 · Shunk, PAThe pilot-in-command's attempted flight into known adverse weather conditions, his failure to maintain control of the aircraft, and his exceeding the airframe design limits resulting in separation of the outboard left wing. Contributing factors were clouds,…Sep 7, 1998 · N453D · DestroyedNTSB MIA98FA239Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Daytona Beach, FLThe pilot's use of the aircraft to commit suicide.Sep 7, 1998 · N922ER · DestroyedNTSB IAD98FA106Accident · 5 fatalField investigationFinal reportPiper PA-46-350P · Centerville, NYThe pilot's inadvertent flight into adverse weather conditions. Factors related to the accident were the pilot's failure to use weather detection equipment and use of airspeeds in excess of limitations.Sep 7, 1998 · N9150X · DestroyedNTSB ANC98LA140Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKThe loss of engine power due to an in-flight fracture of an engine exhaust valve stem assembly. A factor associated with the accident was the lack of suitable terrain for a forced landing.Sep 7, 1998 · N81045 · Substantial damageNTSB NYC98LA182Accident · Serious injuriesLimited investigationFinal reportPiper J3L-65 · Morristown, VTA loss of engine power for undetermined reasons.Sep 6, 1998 · N26712 · Substantial damageNTSB MIA98LA240Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Winnsboro, SCThe loss of engine power for undetermined reasons.Sep 5, 1998 · N28395 · Substantial damageNTSB LAX98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oroville, CAthe pilot's inaccurate preflight and in-flight fuel consumption calculations, which resulted in fuel exhaustion. The pilot's failure to obtain the proper engine power setting charts to use in fuel consumption calculations was also causal.Sep 5, 1998 · N2161G · Substantial damageNTSB LAX98FA282Accident · 1 fatalField investigationFinal reportSimons Lancair 235 · Llano, CAPilot's inadvertent VFR flight into instrument meteorological conditions , which resulted in spatial disorientation and a subsequent loss of aircraft control.Sep 4, 1998 · N1142W · DestroyedNTSB CHI98LA331Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit Lakes, MNAn inadequate preflight inspection by the pilot which resulted in fuel exhaustion and subsequent loss of engine power.Sep 2, 1998 · N6703E · Substantial damageNTSB MIA98LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Kill Devil Hill, NCFailure of the number one cylinder exhaust valve resulting in loss of engine power and a forced landing on unsuitable terrain at which time the aircraft nosed over.Sep 1, 1998 · N50009 · Substantial damageNTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 310R · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.Sep 1, 1998 · N5056J · 2 aircraft · DestroyedNTSB DCA98MA084Accident · No injuriesMajor investigationFinal reportBoeing 727-200 · Jamaica, NYThe failure of the right main landing gear caused by fatigue cracking and stress corrosion cracking of the trunnion bearing support fitting.Aug 31, 1998 · N722DH · Substantial damageNTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…Aug 28, 1998 · N2931Z · DestroyedNTSB SEA98LA172Accident · No injuriesLimited investigationFinal reportBeech V35B · Sagle, IDThe pilot's inadequate in-flight planning/decision which led to fuel starvation.Aug 27, 1998 · N35MM · Substantial damageNTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…Aug 23, 1998 · N7162M · Substantial damageNTSB FTW98LA366Accident · No injuriesLimited investigationFinal reportCessna 152 · Garland, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1998 · N757KA · Substantial damageNTSB ANC98LA129Accident · Minor injuriesLimited investigationFinal reportDrake Kitfox III · Aniak, AKThe pilot's inadequate in-flight planning/decision, and an inadvertent stall. Factors in the accident were the pilot/owner's improper installation and pitch setting of the propeller assembly, and a tailwind.Aug 23, 1998 · N3203N · DestroyedNTSB CHI98FA323Accident · 3 fatalField investigationFinal reportBell 222 · Spencer, IAThe below standard (loose) fit of the 'white' swashplate outer ring pin resulting in fatigue and subsequent separation of the pin, and ultimately the in-flight breakup of the rotorcraft. A factor was the manufacturer's dissemination of the pin which did not…Aug 21, 1998 · N30SV · DestroyedNTSB LAX98LA272Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-20-A1 · Woodland, CAThe pilot's failure during a preflight inspection to detect the damaged propeller from the previous hard landing. The damaged propeller degraded the climb performance capability of the airplane.Aug 18, 1998 · N606F · Substantial damageNTSB FTW98IA361Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Denver, COA hydraulic failure due to a ruptured hydraulic line, preventing the extension of the nose and right main landing gear.Aug 18, 1998 · N66906 · Minor damageNTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.Aug 17, 1998 · N5233D · Substantial damageNTSB FTW98LA362Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Houston, TXThe pilot's failure to refuel the helicopter which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Aug 17, 1998 · N1103R · Substantial damageNTSB NYC98LA168Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-1A · Erial, NJCatastrophic failure of the number 2 engine cylinder, emanating from a corrosion pit on the outside cylinder wall. A factor was the pilot's diminished forward visibility due to oil on the windshield.Aug 16, 1998 · N9364L · DestroyedNTSB MIA98LA227Accident · No injuriesLimited investigationFinal reportMooney M-20F · Rockhill, SCThe pilot's inadequate fuel management which led to fuel exhaustion.Aug 16, 1998 · N6411Q · Substantial damageNTSB IAD98FA095Accident · 3 fatalField investigationFinal reportCessna 152 · Blue Ash, OHthe pilot's inaccurate calculation of the fuel which resulted in exhaustion of fuel and subsequent loss of engine power.Aug 16, 1998 · N93784 · DestroyedNTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.Aug 15, 1998 · N8512X · Substantial damageNTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.Aug 15, 1998 · N8820H · DestroyedNTSB FTW98LA359Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grand Prairie, TXFuel exhaustion due to the pilot's failure to refuel which resulted in the loss of engine power. Factors were the lack of suitable terrain for the forced landing, and the dark night light conditions.Aug 15, 1998 · N8770C · Substantial damageNTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.Aug 15, 1998 · N89648 · Substantial damageNTSB ATL98LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Lantana, FLThe pilot's inadequate preflight inspection of the fuel system that resulted in the loss of engine power due to water contamination. A factor was the rough terrain on the departure end of the runway.Aug 15, 1998 · N8WP · Substantial damageNTSB CHI98FA313Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Dewitt, MIThe rotor failure/malfunction due to debonding of the tail rotor blade. Also causal was the inadequate maintenance inspection of the aircraft by the company and the improper maintenance procedure by other maintenance personnel.Aug 14, 1998 · N8171U · DestroyedNTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.Aug 12, 1998 · N26CH · Substantial damageNTSB MIA98LA221Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Marco Island, FLThe pilot's inadequate fuel management which led to fuel exhaustion. A related factor was the pilot's improper use of the flight controls during autorotation.Aug 12, 1998 · N19BZ · Substantial damageNTSB SEA98LA160Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Oso, WAThe separation of the 90 degree gearbox and tail rotor assembly for undetermined reasons followed by the inability of the pilot-in-command to maintain control of the rotorcraft.Aug 10, 1998 · N1096L · Substantial damageNTSB MIA98LA220Accident · No injuriesLimited investigationFinal reportCessna 188 · Atlantic Ocean (Atlantic Ocean)A complete loss of engine power due to loss of oil pressure, resulting in a force landing on non suitable terrain, and the subsequent sinking of the airplane in deep water.Aug 10, 1998 · N6300G · DestroyedNTSB CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…Aug 10, 1998 · N9350N · DestroyedNTSB NYC98FA164Accident · 1 fatalField investigationFinal reportCessna 150L · Towanda, PAThe pilot's failure to obtain adequate climb and his premature retraction of the flaps. A contributing factor was his inadequate recovery from a bounced landing.Aug 9, 1998 · N19127 · DestroyedNTSB IAD98LA091Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Windsor Twnship, PAThe pilot's mismanagement of the fuel which led to fuel exhaustion and subsequent loss of engine power.Aug 9, 1998 · N8CX · Substantial damageNTSB CHI98LA307Accident · No injuriesLimited investigationFinal reportCessna 150L · Philip, SDthe fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.Aug 9, 1998 · N5413Q · Substantial damageNTSB LAX98FA260Accident · 3 fatalField investigationFinal reportPiper PA-31-T1 · Baker, NVthe pilot's failure to comply with a 12,500-foot altitude restriction placed on the aircraft by an FAA approved maintenance facility due to unresolved oxygen system issues. Contributing to the accident was the pilot's failure to divulge his true physical…Aug 8, 1998 · N6JM · DestroyedNTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…Aug 8, 1998 · N54TM · DestroyedNTSB ATL98LA108Accident · Serious injuriesLimited investigationFinal reportDean R. Fellows Vans RV-6 · Bainbridge, GAThe pilot's failure to properly modify the crankshaft per the manufacturers service instructions for installation of a fixed pitch propeller and to apply proper torque values to the propellers mounting bolts.Aug 8, 1998 · N245DF · Substantial damageNTSB NYC98IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Mcconnellsburg, PAA high altitude encounter with wake vortices.Aug 7, 1998 · N515AU · Minor damage