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 ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Oct 18, 2013 · N11ML · DestroyedNTSB DCA14CA014Accident · Serious injuriesData collectionFinal reportBoeing 767 322 · Houston, TXThe airplane's inadvertent encounter with clear air turbulence during cruise flight, which resulted in a serious injury to a flight attendant.Oct 18, 2013 · N665UA · No damageNTSB CEN14FA010Accident · 1 fatalField investigationFinal reportCessna 177 · Clayton, OKControlled flight into terrain for reasons that could not be determined from the available evidence.Oct 18, 2013 · N30495 · Substantial damageNTSB CEN14FA009Accident · 2 fatalField investigationFinal reportCessna 500 · Derby, KSThe airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…Oct 18, 2013 · N610ED · DestroyedNTSB ENG14IA001Incident · No injuriesIncident investigationFinal reportAirbus A319 132 · Greenville, TXA high pressure turbine 2nd stage blade separation due to stress corrosion cracking in the J channel cooling cavity. The failed blade entered the gas path and caused substantial damage to the low pressure turbine. The engine was subsequently left at a high…Oct 15, 2013 · N516NK · Minor damageNTSB ERA14CA001Accident · No injuriesData collectionFinal reportCessna 172P · Christmas, FLAn inflight collision with a bird during cruise flight.Oct 14, 2013 · N65704 · Substantial damageNTSB CEN14WA029Accident · 14 fatalForeign investigationCessna 208B · Loreto, BCS, MexicoOn October 14, 2013, about 1401 universal time coordinated, a Cessna 208B, XA-TXM, was destroyed when it impacted terrain near Loreto, Baja California Sur, Mexico. The pilot and thirteen passengers on board were fatally injured. The flight originated from the…Oct 14, 2013 · XA-TXM · DestroyedNTSB CEN14LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-300 · Hector, ARAn engine failure due to crankshaft fatigue cracking for reasons that could not be determined based on the available evidence.Oct 14, 2013 · N5605V · Substantial damageNTSB ERA14WA020Accident · 1 fatalForeign investigationBell 407 - NO Series · Gobierno, ArgentinaOn October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…Oct 13, 2013 · LQ-BHT · Substantial damageNTSB CEN14WA013Accident · 2 fatalForeign investigationEnstrom 280 - FX · Wolica Kozia, PolandOn October 12, 2013, about 0928 hours universal coordinated time, an Enstrom 280FX, Poland registration SP-GMB, impacted trees and terrain near Wolica Kozia, Poland. The pilot and passenger were fatally injured. The accident investigation is under the…Oct 12, 2013 · SP-GMB · Substantial damageNTSB CEN14LA053Accident · No injuriesLimited investigationFinal reportCessna 525A · Lincoln, NEThe airplane’s encounter with a flock of American White Pelicans, which resulted in one bird striking the right outboard wing during en route climb from the departure airport.Oct 12, 2013 · N368PK · Substantial damageNTSB ENG14WA002Incident · No injuriesForeign investigationAirbus A330 - 302 · Caines, Australia, AustraliaOn October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…Oct 10, 2013 · B-18358 · Minor damageNTSB ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.Oct 6, 2013 · N909GD · Substantial damageNTSB WPR14CA006Accident · Minor injuriesData collectionFinal reportSiemens Rotorway Exec 162F · Nampa, IDA flight control malfunction during cruise flight for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.Oct 5, 2013 · N104BJ · Substantial damageNTSB CEN14WA536Accident · No injuriesForeign investigationSikorsky S92 · Stavanger, NorwayOn October 4, 2013, at 1435 coordinated universal time (UTC), a Sikorsky S-92A helicopter, Norwegian registration LN-ONW, made an emergency landing on the unmanned and decommissioned Yme oil rig. The two crew members and 12 passengers were uninjured. The…Oct 4, 2013 · LN-ONW · No damageNTSB WPR14CA004Accident · Minor injuriesData collectionFinal reportVenables Zenith CH701 · Snohomish, WAA jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.Oct 3, 2013 · N143TZ · Substantial damageNTSB ERA13CA435Accident · Minor injuriesData collectionFinal reportAeronca 65 CA · Thomaston, GAThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.Sep 30, 2013 · N33879 · Substantial damageNTSB WPR13WA433Accident · 5 fatalForeign investigationBell 212 - NO Series · Murbad, Thane District, India, IndiaOn September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…Sep 29, 2013 · VT-HGB · DestroyedNTSB ENG13WA043Incident · No injuriesClass 5 · ForeignBoeing 737 - 53C · Cusco, PeruOn September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…Sep 27, 2013 · OB-2041-P · No damageNTSB CEN13LA565Accident · No injuriesLimited investigationFinal reportCessna 210-5(205) · Weatherford, OKThe pilot’s inadequate preflight inspection and fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.Sep 25, 2013 · N8472Z · Substantial damageNTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.Sep 25, 2013 · N4623M · DestroyedNTSB CEN13LA557Accident · Serious injuriesLimited investigationFinal reportBeech 35 B33 · Urbana, INThe failure of the crankshaft following several overheating events that had led to a stress crack and the subsequent fracture forward of the No. 6 rod journal.Sep 24, 2013 · N8910M · Substantial damageNTSB WPR13WA423Accident · 1 fatalForeign investigationCessna 182 - R · Hamilton Aerodrome, Australia, AustraliaOn September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…Sep 23, 2013 · VH-AUT · Substantial damageNTSB ERA13LA428Accident · No injuriesLimited investigationFinal reportBeech A36 · Wellington, FLA total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…Sep 23, 2013 · N40KG · Substantial damageNTSB CEN13LA562Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Mack, COA total loss of engine power due to the failure of the engine crankshaft, which resulted from maintenance personnel’s application of insufficient torque on the engine case through bolts.Sep 23, 2013 · N426TF · Substantial damageNTSB WPR13FA417Accident · 2 fatalField investigationFinal reportBell UH-1V · Cordes Lakes, AZThe pilot's improper maintenance on the helicopter’s main rotor blade pitch control system, which resulted in an in-flight loss of main rotor blade pitch control, mast bumping, and mast failure.Sep 21, 2013 · N22490 · DestroyedNTSB ERA13CA427Accident · Minor injuriesData collectionFinal reportCessna 182E · Middletown Springs, VTThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Sep 21, 2013 · N3152Y · Substantial damageNTSB ERA13LA421Accident · Serious injuriesLimited investigationFinal reportAmerican Eurocopter AS350B2 · Canton, MSThe pilot’s improper decision to continue flight with a low engine oil pressure warning light instead of landing immediately in accordance with the flight manual emergency checklist. Contributing to the accident was the maintenance technician’s failure to…Sep 20, 2013 · N810LE · Substantial damageNTSB DCA13WA158Incident · No injuriesForeign investigationBoeing 757 223 · San Andreas, ColombiaThe CAA of Colombia has notified the NTSB of an incident involving a Boeing 757-223 airplane that occurred on September 19, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of Colombia's investigation under the provisions of…Sep 19, 2013 · N676AN · No damageNTSB DCA13WA159Incident · No injuriesForeign investigationBoeing 787 - 8QQ · Warsaw, PolandOn September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…Sep 18, 2013 · SP-LRB · No damageNTSB WPR13WA410Accident · 2 fatalForeign investigationCessna U206 - G · Croydon, AustraliaOn September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…Sep 15, 2013 · VH-WAV · DestroyedNTSB ERA13CA420Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS 6 · Sussex, NJThe pilot's improper selection of an off-airport landing site, and his subsequent failure to maintain clearance from trees during a crosswind landing in gusty wind conditions.Sep 13, 2013 · N650DP · Substantial damageNTSB ANC13LA100Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Kotzebue, AKThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Sep 13, 2013 · N8316Q · Substantial damageNTSB ERA13LA408Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Woodstock, CTThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.Sep 8, 2013 · N7333P · Substantial damageNTSB ERA13LA407Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Guntersville, ALThe improper installation of the engine magneto by unknown maintenance personnel, which resulted in the magneto separating from the engine and a subsequent total loss of engine power. Contributing to the accident was the pilot's delay in proceeding directly…Sep 8, 2013 · N8362C · Substantial damageNTSB CEN13LA536Accident · Minor injuriesLimited investigationFinal reportSweet Wayne A Bushby Mustang II · Woodstock, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Sep 8, 2013 · N54WS · Substantial damageNTSB DCA13WA168Accident · Minor injuriesForeign investigationCessna 206 - H · Kodoeskop, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T206H airplane that occurred on September 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…Sep 7, 2013 · ZS-PXV · Substantial damageNTSB ERA13LA405Accident · Minor injuriesLimited investigationFinal reportCrowder Michael H Sonex · Waxhaw, NCThe pilot/owner/builder’s improper routing of the engine’s crankshaft position sensor cable next to the engine’s exhaust system, which resulted in a total loss of engine power in flight.Sep 6, 2013 · N293SX · Substantial damageNTSB ANC13LA102Accident · No injuriesLimited investigationFinal reportPiper J3L-65 · Nondalton, AKThe fracture and subsequent failure of the No. 4 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.Sep 5, 2013 · N38262 · Substantial damageNTSB CEN13WA527Accident · 2 fatalForeign investigationCessna T303 · JerseySep 4, 2013 · N289CW · Substantial damageNTSB WPR13LA396Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Sisters, ORThe pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…Sep 2, 2013 · N102HA · Substantial damageNTSB CEN13LA518Accident · Minor injuriesLimited investigationFinal reportAmerican Champion 7GCB · Pearsall, TXThe failure of the rudder cable due to electrical arcing damage from contact with an unguarded battery and the pilot's subsequent loss of control during the go-around.Sep 2, 2013 · N9967Y · Substantial damageNTSB DCA13WA176Accident · Serious injuriesForeign investigationAirbus A330 - 203 · Fortaleza, BrazilThe Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA) has notified the NTSB of an accident involving an Airbus A330-203, registration PT-MVL, which occurred on September 1, 2013. The NTSB has appointed a U.S. Accredited…Sep 1, 2013 · PT-MVL · No damageNTSB ERA13WA439Accident · No injuriesForeign investigationBell 206B · Matoes do Norte, BrazilOn August 30, 2013, at 1555 coordinated universal time (1255 local time), a Bell 206B, Brazilian registration PT-HUE, was substantially damaged following a loss of engine power and a subsequent forced landing in Matões do Norte, Maranhão, Brazil. The pilot…Aug 30, 2013 · PT-HUE · Substantial damageNTSB ERA13CA389Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Blairsville, GAThe pilot’s decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and subsequent inability to maintain clearance with terrain.Aug 30, 2013 · N447JP · Substantial damageNTSB ENG13WA042Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandThe investigation is under the jurisdiction of the government of New Zealand. Further information pertaining to this accident may be obtained from:Transport Accident Investigation Commission PO Box 10323, The Terrace Wellington 6143, New Zealand. Website :…Aug 30, 2013 · ZK-NGI · No damageNTSB WPR13LA390Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Payson, AZA partial loss of engine power due to an overtemperature event that thermally damaged the turbine blades and vanes, which resulted in a hard landing.Aug 28, 2013 · N2018R · Substantial damageNTSB WPR13LA389Accident · Serious injuriesLimited investigationFinal reportChampion 8KCAB · Wahiawa, HIA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Aug 28, 2013 · N413JJ · Substantial damageNTSB CEN13LA514Accident · Minor injuriesLimited investigationFinal reportChallenger II · Emporia, KSThe right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.Aug 28, 2013 · UNREG · Substantial damageNTSB ANC13LA085Accident · No injuriesLimited investigationFinal reportCessna U206F · Tokotna, AKA total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic’s application of insufficient torque on the cylinder through bolts.Aug 24, 2013 · N35952 · Substantial damage