OpenAirDocs.org

NTSB investigations

35,883 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 ERA18WA274Accident · 2 fatalForeign investigationPiper PA28 · Nafpaktos, GreeceThe government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of…Apr 21, 2018 · SX-SEX · Substantial damageNTSB GAA18CA233Accident · No injuriesData collectionFinal reportMooney M20F · Bulberde, TXThe pilot’s unstabilized approach, which resulted in the airplane landing long and fast, and the pilot’s subsequent decision to steer the airplane off the side of the runway to avoid a runway overrun.Apr 19, 2018 · N3535X · Substantial damageNTSB WPR18TA122Accident · Minor injuriesClass 3Final reportWilhelm Puslar · Salton City, CAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to perform the loss of engine power emergency procedures, which likely would have restored engine…Apr 18, 2018 · N332RP · Substantial damageNTSB DCA18WA155Incident · No injuriesForeign investigationBoeing 737 · MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Apr 18, 2018 · XA-UQA · No damageNTSB DCA18WA149Incident · No injuriesForeign investigationBoeing 737 500 · Cuzco, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 500 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…Apr 18, 2018 · N240AT · No damageNTSB ERA18WA173Accident · No injuriesForeign investigationBell Helicopter 407 · Nova Esperanca, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on April 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Apr 17, 2018 · PT-YZJ · Substantial damageNTSB DCA18MA142Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737 7H4 · Philadelphia, PAA low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…Apr 17, 2018 · N772SW · Substantial damageNTSB ERA18FA127Accident · 1 fatalField investigationFinal reportCessna 525 · Crozet, VAThe pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting…Apr 16, 2018 · N525P · DestroyedNTSB CEN18FA143Accident · 2 fatalField investigationFinal reportBeech G33 · Warsaw, OHThe pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing…Apr 16, 2018 · N9345Q · Substantial damageNTSB CEN18FA140Accident · 2 fatalField investigationFinal reportBordiuk Challenger II · Friona, TXAn in-flight impact with terrain for reasons that could not be determined due to a lack of evidence.Apr 16, 2018 · N635DT · Substantial damageNTSB CEN18LA142Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado Springs, COThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 15, 2018 · N6988N · Substantial damageNTSB CEN18FA139Accident · 1 fatalField investigationFinal reportWittman W10 · San Antonio, TXAn in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control.Apr 15, 2018 · N625JS · DestroyedNTSB WPR18LA120Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Kernville, CAA total loss of engine power due to air or fuel vapor entering the fuel system, which prevented fuel from reaching the engine cylinders, which necessitated an emergency landing, during which the airplane nosed over.Apr 14, 2018 · N830AZ · Substantial damageNTSB ERA18FA128Accident · 1 fatalField investigationFinal reportS.Z.D. SZD 48 Jantar STD 2 · LaBelle, FLThe pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence.Apr 14, 2018 · N456RM · Substantial damageNTSB DCA18WA151Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Apr 12, 2018 · XA-UZW · No damageNTSB DCA18WA157Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Safety Investigation Board has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under…Apr 11, 2018 · AP-BMU · Minor damageNTSB DCA18WA154Incident · No injuriesForeign investigationEmbraer S A ERJ170-200LR · MexicoThe government of Mexico has notified the NTSB of an incident involving a EMBRAER S A ERJ170-200LR airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…Apr 11, 2018 · N89313 · Minor damageNTSB ANC18LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Atqasuk, AKThe pilot's decision to continue a visual flight rules flight into an area of instrument meteorological conditions and his subsequent failure to level the airplane after the autopilot disconnected, which resulted in a collision with terrain.Apr 11, 2018 · N814GV · Substantial damageNTSB ERA18WA130Accident · 4 fatalForeign investigationBeech 58 · Tucuman, ArgentinaApr 10, 2018 · N6926Z · DestroyedNTSB DCA18WA153Incident · No injuriesForeign investigationAirbus A319 115 · MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A319 115 airplane that occurred on April 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Apr 10, 2018 · N70020 · No damageNTSB ERA18WA131Accident · No injuriesForeign investigationPiper PA34-200T · La Pampa, ArgentinaApr 8, 2018 · LV-GZK · DestroyedNTSB ERA18LA124Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Lowville, NYThe pilot's diverted attention, which resulted in his inadequate monitoring of the airplane's attitude and a loss of control in flight.Apr 8, 2018 · C-GMDQ · Substantial damageNTSB DCA18WA130Incident · No injuriesForeign investigationBoeing 737 · Rio de Janeiro, BrazilThe government of Brazil has notified the NTSB of an serious incident involving a BOEING 737 airplane that occurred on April 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Apr 6, 2018 · PR-GGE · No damageNTSB CEN18WA402Accident · 1 fatalForeign investigationRotorway Exec · Crestet, FranceThe government of France has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under…Apr 5, 2018 · F-PFBJ · DestroyedNTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…Apr 2, 2018 · N68640 · Substantial damageNTSB ERA18WA123Accident · 4 fatalForeign investigationRobinson R44 · Rosario, BrazilApr 1, 2018 · PP-WVR · Substantial damageNTSB ERA18LA119Accident · 2 fatalLimited investigationFinal reportAmes Angier M LNC2 · Atlantic Ocean (Atlantic Ocean)The pilot's spatial disorientation after entering instrument meteorological conditions and encountering moderate-to-heavy precipitation, which resulted in a loss of airplane control.Mar 31, 2018 · N4ZQ · Substantial damageNTSB CEN18LA131Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grove, OKA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat immediately following the loss of engine power.Mar 31, 2018 · N2485C · Substantial damageNTSB DCA18WA124Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 757 airplane that occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…Mar 29, 2018 · HP1910DAE · No damageNTSB ERA18FA118Accident · 1 fatalField investigationFinal reportCessna R182 · Ashville, ALDescent and impact with terrain for reasons that could not be determined.Mar 28, 2018 · N3167C · DestroyedNTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…Mar 26, 2018 · N7019N · DestroyedNTSB CEN18LA127Accident · Minor injuriesLimited investigationFinal reportMX MXS · Fulton, TXA total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway.Mar 25, 2018 · N540JH · Substantial damageNTSB ERA18LA113Accident · No injuriesLimited investigationFinal reportFairchild Funk M62C F 23A · Columbia, TNThe pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power.Mar 23, 2018 · N1131Z · Substantial damageNTSB ERA18LA112Accident · Serious injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G V · Miami, FLThe passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter.Mar 21, 2018 · N90JE · No damageNTSB WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.Mar 20, 2018 · N925DP · Substantial damageNTSB GAA18CA172Accident · No injuriesData collectionFinal reportLithuanian Factory Of LAK 12 · Sunriver, ORThe glider pilot's inadequate flight planning, which resulted in an off-airport landing.Mar 20, 2018 · N63010 · Substantial damageNTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.Mar 17, 2018 · N27265 · DestroyedNTSB GAA18CA168Accident · Minor injuriesData collectionFinal reportHughes 269 · San Antonio, TXThe pilot’s decision to relinquish the helicopter flight controls to a non-rated passenger during a 3 ft hover.Mar 14, 2018 · N11047 · Substantial damageNTSB CEN18LA124Accident · Serious injuriesLimited investigationFinal reportWhite Thorpe T 18 · Cleburne, TXThe loss of engine power due to fuel exhaustion.Mar 14, 2018 · N118RG · Substantial damageNTSB GAA18CA162Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Punta Gorda, FLA collision with a large bird during approach.Mar 13, 2018 · N989G · Substantial damageNTSB GAA18CA152Accident · Minor injuriesData collectionFinal reportPiper PA 32R · Big Spring, TXThe pilot’s failure to manage the airplane’s fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s decision to attempt the flight with an inoperative fuel gauge.Mar 9, 2018 · N8191B · Substantial damageNTSB CEN18LA118Accident · Minor injuriesLimited investigationFinal reportBereznak Lancair Legacy · Temple, TXThe failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation.Mar 8, 2018 · N60JN · DestroyedNTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.Mar 5, 2018 · N669WH · Substantial damageNTSB WPR18LA098Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon A36 · Enumclaw, WAA total loss of engine power due to oil starvation as a result of a loose oil line B-nut.Mar 4, 2018 · N207PC · Substantial damageNTSB GAA18CA184Accident · No injuriesData collectionFinal reportPiper PA32 · Camas, WAThe pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation.Mar 4, 2018 · N3756W · Substantial damageNTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.Mar 1, 2018 · N77MM · Substantial damageNTSB ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.Mar 1, 2018 · N615JA · DestroyedNTSB ENG18RA020Incident · No injuriesForeign investigationAvro RJ85 · Bishkek, KyrgyzstanOn March 1, 2018, a Tez Jet Airline Avro RJ85, powered by four Honeywell (formally Lycoming) LF507-1F turbofan engines experienced an uncontained No. 1 (left most) engine turbine failure during climb. The airplane returned to the Bishkek-Manas International…Mar 1, 2018 · EX-27005 · Minor damageNTSB CEN18WA133Incident · No injuriesForeign investigationCessna 182P · Abbeville, FranceOn February 28, 2018, about 0845 universal coordinated time (UTC), a Cessna 182P airplane, N609PC, had an inflight engine failure and subsequent forced landing near Abbeville, France. The pilot and passenger were uninjured, and the airplane sustained minor…Feb 28, 2018 · N609PC · Minor damageNTSB ERA18WA100Accident · 1 fatalForeign investigationBeech V35B · Brasilandia, Mato Grosso do Sul, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Feb 27, 2018 · PT-IEL · Substantial damage