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 GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.Jun 29, 2019 · N998DM · Substantial damageNTSB ERA19WA207Accident · 4 fatalForeign investigationPiper PA 28-180 · Cabo Rojo, Dominican RepublicJun 29, 2019 · N55784 · DestroyedNTSB CEN19LA199Accident · Serious injuriesClass 3 · LimitedFinal reportZenair CH750 Stol · Paducah, KYA stuck exhaust valve that resulted in a loss of engine power and a forced landing to rough terrain.Jun 29, 2019 · N170MV · Substantial damageNTSB CEN19LA188Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 560 · Janesville, WIThe passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.Jun 27, 2019 · N318RW · Minor damageNTSB CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.Jun 22, 2019 · N63WC · Substantial damageNTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.Jun 21, 2019 · N243XT · Substantial damageNTSB CEN19FA177Accident · 2 fatalField investigationFinal reportBeech A36 · Elida, OHThe noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…Jun 20, 2019 · N6150X · DestroyedNTSB ENG19RA027Accident · No injuriesForeign investigationAerospatiale AS355 · Dryden, Ontario, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale AS355 F2 rotorcraft that occurred on June 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the TSB under the provisions…Jun 19, 2019 · C-GCZS · DestroyedNTSB WPR19FA175Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Two Harbors, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 18, 2019 · N7187D · DestroyedNTSB CEN19LA175Accident · Minor injuriesClass 3 · LimitedFinal reportFlightstar FC-II · Knoxville, TNA total loss of engine power for reasons that could not be determined based on available evidence.Jun 18, 2019 · N354AR · DestroyedNTSB WPR19FA172Accident · 1 fatalClass 3 · FieldFinal reportNanchang CJ6 · Porter Ranch, CAThe pilot’s continued flight into marginal visual meteorological conditions, which resulted in controlled flight into terrain.Jun 15, 2019 · N269AG · Substantial damageNTSB CEN19FA170Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Huntsville, TXA total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.Jun 14, 2019 · N9754J · DestroyedNTSB WPR19LA170Accident · Serious injuriesClass 3 · LimitedFinal reportJames Experimental Cub · Stanley, IDOverstress failure of the right-wing spar due to an encounter with turbulence.Jun 13, 2019 · N9WU · Substantial damageNTSB ANC19WA025Accident · No injuriesForeign investigationCirrus SR20 · Yeosu, South KoreaThe government of Korea has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea's investigation under the provisions of…Jun 13, 2019 · HL1258NTSB CEN19WA273Accident · No injuriesForeign investigationAgustaWestland AW139 · Albarracín, SpainOn June 12, 2019, about 1330 local time, an AgustaWestland AW139 helicopter, EC-NEH, executed an emergency landing to an open field near Albarracín, Spain, for unknown reasons. The pilot and sole occupant sustained no injury, and the helicopter sustained…Jun 12, 2019 · EC-NEH · Substantial damageNTSB ANC19LA027Accident · No injuriesClass 3 · LimitedFinal reportHelio H391 · Hope, AKThe pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.Jun 12, 2019 · N10CJ · Substantial damageNTSB CEN19LA163Accident · Serious injuriesClass 3 · LimitedFinal reportGriff Challenger · Switz City, INA total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.Jun 11, 2019 · N582L · Substantial damageNTSB WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.Jun 10, 2019 · N3997Y · Substantial damageNTSB GAA19CA338Accident · No injuriesData collectionFinal reportPzl-Swidnik PW-5 · Independence, WIThe separation of the canopy from the glider during an off-airport landing for reasons that could not be determined.Jun 10, 2019 · N962JH · Substantial damageNTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.Jun 10, 2019 · N622MM · DestroyedNTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…Jun 8, 2019 · N8014T · DestroyedNTSB WPR19LA160Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Davis City, CAA total loss of engine power due to water contamination in the fuel, which resulted in a forced landing and collision with terrain. Contributing to the accident was the pilot's improper decision to proceed with the flight after discovering the contaminated…Jun 7, 2019 · N6617F · Substantial damageNTSB ERA19FA188Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Castalia, NCThe pilot’s failure to navigate around hazardous weather, resulting in the penetration of a thunderstorm, a loss of airplane control, and an inflight breakup. The air traffic controller’s failure to provide the pilot with adequate and timely weather…Jun 7, 2019 · N709CH · DestroyedNTSB GAA19WA414Incident · No injuriesForeign investigationCessna 207 · Birtingarholt, IcelandJun 6, 2019 · TF-MAJ · No damageNTSB ANC19WA022Accident · 3 fatalForeign investigationGrumman AA-5B · Medicine Hat, CanadaOn June 2, 2019, at 0440 (UTC) time, a Canadian registered Grumman American Aviation, AA-5B airplane, C-GQIJ, operated by a private individual, was found after it had collided with terrain under unknown circumstances while conducting a VFR flight. A search…Jun 2, 2019 · C-GQIJ · Substantial damageNTSB DCA19WA156Incident · No injuriesForeign investigationBoeing 787 · JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 787 airplane that occurred on June 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…Jun 1, 2019 · JA828A · No damageNTSB ENG19WA026Incident · No injuriesForeign investigationAirbus A330 · Chek Lap Kok, Hong Kong SAR ChinaThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an incident involving an Airbus A330-302 airplane which occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of…May 30, 2019 · B-18352NTSB CEN19LA159Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Cleburne, TXA total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.May 30, 2019 · N2514F · Substantial damageNTSB GAA19WA334Accident · 2 fatalForeign investigationPiper PA12 · Gillam (Manitoba)-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a PIPER PA12 airplane that occurred on May 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…May 29, 2019 · C-FYDN · DestroyedNTSB CEN19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Fredericksburg, TXThe loss of engine power for undetermined reasons.May 29, 2019 · N60955 · Substantial damageNTSB ERA19FA181Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Auburn Township, OHThe pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.May 28, 2019 · N3933T · DestroyedNTSB DCA19CA153Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · Fort Lauderdale, FLA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the pot locking lever was raised.May 28, 2019 · N507JT · No damageNTSB CEN19FA155Accident · 1 fatalClass 3 · FieldFinal reportCessna R172 · Mertzon, TXThe pilot's loss of control due to spatial disorientation.May 28, 2019 · N2583V · DestroyedNTSB GAA19WA308Accident · 3 fatalForeign investigationPiper PA28 · Estancia County, BrazilMay 27, 2019 · PT-KLO · DestroyedNTSB CEN19LA152Accident · Minor injuriesClass 3 · LimitedFinal reportRand Robinson KR2 · Poplar Grove, ILThe loss of engine power due to vapor lock of the throttle body injection system.May 26, 2019 · N886MJ · Substantial damageNTSB DCA19CA151Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737-8H4 · Waycross, GAan encounter with convectively induced turbulence while penetrating cumulus clouds during descent.May 25, 2019 · N8697C · No damageNTSB CEN19LA153Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 8KCAB · Fredericksburg, TXA total loss of engine power due to fuel exhaustion.May 25, 2019 · N68557 · Substantial damageNTSB WPR19FA154Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Grover, UTThe pilot's encounter with moderate to severe icing conditions during cruise flight, which resulted in structural icing and a subsequent loss of control. Contributing to the accident was the pilot’s decision to continue a flight route through known moderate…May 24, 2019 · N809SR · DestroyedNTSB ERA19LA180Accident · 1 fatalLimited investigationFinal reportCessna 560 · Atlantic Ocean (Atlantic Ocean)Impact with water for reasons that could not be determined based on the available information.May 24, 2019 · N832R · DestroyedNTSB GAA19WA273Accident · No injuriesForeign investigationCirrus SR20 · Wilhelmshaven, Germany, GermanyThe government of Germany has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on May 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…May 19, 2019 · D-EXOS · DestroyedNTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…May 18, 2019 · N596JB · DestroyedNTSB WPR19FA148Accident · 2 fatalClass 3 · FieldFinal reportRobinson R44 · Alpine, UTThe noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…May 17, 2019 · N744TW · Substantial damageNTSB CEN19LA147Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210 · Yankeetown, FLA loss of engine power for reasons that could not be determined based on the available evidence.May 17, 2019 · N4861P · Substantial damageNTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.May 16, 2019 · N6753W · Substantial damageNTSB ERA19LA177Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Savannah, TNThe total loss of engine power due to a loss of all electrical power. Contributing to the accident was the inaccessible placement of the alternator circuit breaker and the construction of the airplane without a backup electrical source.May 16, 2019 · N750GZ · Substantial damageNTSB WPR19FA146Accident · 1 fatalClass 3 · FieldFinal reportAviat A1 · Santa Ynez, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight in low visibility and mountainous obscuration conditions.May 15, 2019 · N236AM · DestroyedNTSB WPR19FA145Accident · 2 fatalClass 3 · FieldFinal reportGrumman G164 · Pleasant Grove, CAThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.May 15, 2019 · N6787K · 2 aircraft · Substantial damageNTSB CEN19LA146Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Morrilton, ARThe improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.May 15, 2019 · N761AF · Substantial damageNTSB DCA19WA172Accident · Serious injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe ARAIB of Korea has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB's investigation under the provisions of ICAO Annex 13 as State…May 13, 2019 · HL7726 · No damageNTSB DCA19WA150Incident · No injuriesForeign investigationAirbus A330 · Derby, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of a serious incident involving a AIRBUS A330 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…May 13, 2019 · unknown · No damage