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 CEN16WA120Accident · No injuriesForeign investigationCessna 152 · Agostyan, HungaryOn February 28, 2016, at 1003 UTC, a Cessna FA152 (S/N 0346), HA-VOK, impacted wooded terrain near Agostyán, Tata, Hungary. The aircraft was destroyed and the two occupants on board were fatally injured. The aircraft was enroute to Godollo Airport (LHGD),…Feb 28, 2016 · HA-VOK · DestroyedNTSB CEN16LA115Accident · No injuriesLimited investigationFinal reportBeech V35 · Seymour, INThe pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…Feb 27, 2016 · N2714T · Substantial damageNTSB ENG16WA018Accident · 25 fatalForeign investigationViking Air DHC-6 · Soli Ghoptevir, NepalFeb 24, 2016 · 9N-AHH · DestroyedNTSB ERA16LA110Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Palatka, FLA partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.Feb 23, 2016 · N256CD · Substantial damageNTSB ERA16LA109Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Port Jefferson, NYThe flight instructor's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Feb 21, 2016 · N29099 · Substantial damageNTSB ERA16FA108Accident · 1 fatalField investigationFinal reportBeech A36 · Marshville, NCThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.Feb 19, 2016 · N61WB · Substantial damageNTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.Feb 18, 2016 · N80918 · Substantial damageNTSB CEN16LA107Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Bryan, TXA failure of the crankshaft due to improper torque of the crankcase through bolts.Feb 16, 2016 · N732FU · Substantial damageNTSB DCA16CA089Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 132 · Minneapolis, MNan encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.Feb 14, 2016 · N827AW · No damageNTSB DCA16LA096Accident · No injuriesLimited investigationFinal reportLockheed 382G · Iliamna, AKThe fatigue failure of the forward pressure bulkhead canted web that originated from stress corrosion cracking areas. Contributing to the failure were inspection procedures and intervals inadequate to identify the crack.Feb 12, 2016 · N401LC · Substantial damageNTSB CEN16WA104Accident · 1 fatalForeign investigationCessna 172 · Jaen, SpainFeb 10, 2016 · EC-LSY · DestroyedNTSB WPR16LA066Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Santa Barbara, CAA total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.Feb 9, 2016 · N113TM · Substantial damageNTSB ERA16CA105Accident · No injuriesData collectionFinal reportPiper PA34 · Williamsport, PAThe pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.Feb 9, 2016 · N234NC · Substantial damageNTSB DCA16WA099Incident · No injuriesForeign investigationBombardier DHC8 · Calgary, Alberta, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a Bombardier DHC8-402 that occurred on February 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…Feb 9, 2016 · C-GWEP · Minor damageNTSB ERA16WA107Accident · 1 fatalForeign investigationBell 206 · Bejucal, VenezuelaOn February 6, 2016, about 1710 universal coordinated time, a Bell 206 L-3 helicopter, Venezuelan registration YV250T, was destroyed when it collided with terrain after a loss of control in flight. The flight originated at the Aerópuerto De San Juan De Los…Feb 6, 2016 · YV250T · DestroyedNTSB WPR16LA081Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Ashland, ORFatigue cracking of a main rotor blade for reasons that could not be determined based on the available information.Feb 5, 2016 · N745BW · Substantial damageNTSB DCA16WA085Incident · No injuriesForeign investigationSikorsky S76 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a Sikorsky S76C helicopter that occurred on February 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…Feb 3, 2016 · 5N-BQJ · Substantial damageNTSB ERA16LA103Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Miami, FLA partial loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical anomalies that would have contributed to the power loss.Feb 2, 2016 · N8466G · Substantial damageNTSB WPR16LA060Accident · No injuriesLimited investigationFinal reportPiper PA46 · Burns, ORThe total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…Jan 31, 2016 · N777PG · Substantial damageNTSB WPR16WA062Accident · 4 fatalForeign investigationPiper PA28 · Barwon Heads, Australia, AustraliaOn January 29, 2016, at 1155 local time, a Piper PA 28-235, VH-PXD, was ditched in the waters near Barwon Heads, Australia. The airplane was operated by a private individual under the pertinent regulations of the Government of Australia. The airplane was…Jan 29, 2016 · VH-PXD · DestroyedNTSB ERA16LA098Accident · No injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Shoals, WVThe improper locking of the rear passenger door by the specialty nurse, which resulted in the door separating from the helicopter in flight.Jan 29, 2016 · N133HN · Substantial damageNTSB DCA16CA077Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Titusville, FLan inadvertent encounter with clear air turbulence.Jan 28, 2016 · N718SW · No damageNTSB ERA16LA094Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Lindenhurst, NYA rough running engine as a result of an intermittent failure of the left magneto for reasons that could not be determined, which resulted in a subsequent autorotation, impact with a sign, and rollover.Jan 27, 2016 · N404LE · Substantial damageNTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…Jan 25, 2016 · HS-TXN · No damageNTSB WPR16WA191Accident · No injuriesForeign investigationVans RV8 · Chiang Mai, ThailandOn January 24, 2016, about 1030 local time, a Van RV-8, HS-GMC, initiated a forced landing near Chiang Mai, Thailand after experiencing a total loss of engine power during cruise flight. The owner/pilot, and one passenger, were not injured; the airplane…Jan 24, 2016 · HS-GMC · Substantial damageNTSB GAA16CA107Accident · Minor injuriesData collectionFinal reportPiper PA 46 · Ottawa, KSThe flight crews encounter with un-forecasted freezing rain resulting in an uncontrolled descent, forced landing, and substantial damage to the airplane's firewall, and forward pressure bulkhead.Jan 19, 2016 · N113WB · Substantial damageNTSB WPR16FA055Accident · Serious injuriesField investigationFinal reportAirbus EC130 · Hanalei, HIThe fatigue failure of the engine fuel pipe as a result of vibration caused by a worn starter-generator front bearing support, which excited the fuel pipe and caused it to oscillate at a resonant frequency, and a subsequent loss of engine power due to fuel…Jan 18, 2016 · N11VQ · Substantial damageNTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…Jan 18, 2016 · N711BX · DestroyedNTSB ERA16LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madison, GAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jan 18, 2016 · N6135M · Substantial damageNTSB CEN16LA090Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Overbrook, OKThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.Jan 17, 2016 · N194DW · Substantial damageNTSB CEN16WA088Accident · 4 fatalForeign investigationSocata TB20 · Cuenca, Spain, SpainOn January 16, 2016, about 1532 coordinated universal time, a Socata TB-20 single engine airplane, serial number 747, registry EC-ESK, was destroyed after impacting terrain near Cuenca, Spain, during cruise flight. The pilot and three passengers were fatally…Jan 16, 2016 · EC-ESK · DestroyedNTSB ERA16FA089Accident · 1 fatalField investigationFinal reportCaughran Terry Flightstar II · Wake, VAFailure of the left wing in flight due to compression loading from wing loads combined with preexisting damage.Jan 14, 2016 · N82652 · Substantial damageNTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.Jan 14, 2016 · N4751Z · DestroyedNTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…Jan 14, 2016 · N2025D · DestroyedNTSB ENG16WA008Incident · No injuriesForeign investigationBoeing 767 · Lima, PeruOn January 11, 2016, a Boeing 767-316ER, powered by two General Electric CF6-80C2B6F turbofan engines experienced an inflight uncommnaded shutdown of the right engine. The engine was successfully restarted and the flight continued to its intended destination.…Jan 11, 2016 · CC-CXK · No damageNTSB DCA16RA045Accident · 2 fatalForeign investigationBombardier CL600 2B19 · Kiruna, SwedenimportJan 8, 2016 · SE-DUX · DestroyedNTSB CEN16WA074Accident · 1 fatalForeign investigationCirrus SR20 · Egmond, NetherlandsOn January 4, 2016, about 1356 UTC, a Cirrus Design, Incorporated SR-20, United Kingdom registration G-ZOGT, owned by a private individual, was destroyed when it impacted into the North Sea near Egmond aan Zee, The Netherlands, under unknown circumstances.…Jan 4, 2016 · G-ZOGT · DestroyedNTSB CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.Jan 4, 2016 · N5104D · Substantial damageNTSB DCA16CA041Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Raleigh, NCan encounter with turbulence resulting in a serious injury to a flight attendant.Jan 3, 2016 · N643RW · No damageNTSB WPR16LA047Accident · No injuriesLimited investigationFinal reportKevin Metzler Velocity STD RG · Rosamond, CAA partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.Jan 2, 2016 · N133SV · Substantial damageNTSB ANC16LA012Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Anaktuvuk Pass, AKThe pilot’s continued flight into deteriorating, flat light weather conditions, which resulted in impact with mountainous, snow-covered terrain.Jan 2, 2016 · N540ME · Substantial damageNTSB ERA16WA081Accident · Serious injuriesForeign investigationBell 429 · Rostov-na-Dony, RussiaSubject: ERA16WA081 Bell 429, RA-01617, Rostov-na-Dony, Russia On January 1, 2016, about 0621 universal coordinated time, a Bell 429, Russian registration RA-01617, was substantially damaged by collision with terrain during an uncontrolled descent following a…Jan 1, 2016 · RA-01617 · DestroyedNTSB DCA16WA040Incident · No injuriesForeign investigationBoeing 777-333ER · Calgary, CanadaThe NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…Dec 31, 2015 · C-FRAM · No damageNTSB CEN16LA079Accident · Serious injuriesLimited investigationFinal reportPiper 28-140 · Republic, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.Dec 31, 2015 · N4643R · DestroyedNTSB CEN16LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot’s improper in-flight 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 switch fuel tanks after the engine lost power, and his delayed decision to activate…Dec 27, 2015 · N5PF · Substantial damageNTSB DCA16WA048Incident · No injuriesForeign investigationBoeing 737 · Gwangju-Si, South KoreaThe government of Republic Of Korea has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Republic Of Korea's investigation…Dec 23, 2015 · HL8049 · No damageNTSB CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.Dec 23, 2015 · N4523A · Substantial damageNTSB GAA16CA099Accident · No injuriesData collectionFinal reportDavis Michael J MD Special · Wallace, NCThe pilot's improper fuel planning, which resulted in fuel exhaustion.Dec 21, 2015 · N141MD · Substantial damageNTSB DCA16WA037Incident · No injuriesForeign investigationBoeing 787 · Darwin, AustraliaThe government of Australia has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on December 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Dec 21, 2015 · VH-VKE · No damageNTSB ERA16FA075Accident · 1 fatalField investigationFinal reportBeech C24R · Winder, GAA total loss of engine power for reasons that could not be determined because the examination of the wreckage did not reveal any mechanical anomalies that would have precluded normal operation.Dec 20, 2015 · N2074P · Destroyed