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 ERA16LA172Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Tyrone, GAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.Apr 30, 2016 · N7620B · Substantial damageNTSB ERA16WA196Accident · No injuriesForeign investigationSikorsky S76 · Campos dos Goytacazes, BrazilOn April 28, 2016, about 1330 coordinated universal time, a Sikorsky S76A, Brazilian registration PR-EMR, was substantially damaged during an emergency landing after a fire indication and precautionary engine shutdown on the right engine followed shortly by a…Apr 28, 2016 · PR-EMR · Substantial damageNTSB ERA16LA265Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PAMaintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.Apr 26, 2016 · N145HN · Substantial damageNTSB CEN16WA179Accident · No injuriesForeign investigationSwearingen SA 226T · Andorra, Lleida, Spain, SpainOn April 26, 2016, about 1535 hours universal coordinated time, a Swearingen SA-226T airplane, United States registration N125WG, was substantially damaged during landing at the Andorra – La Seu d'Urgell Airport (LESU); Andorra, Lleida, Spain. The airplane…Apr 26, 2016 · N125WG · Substantial damageNTSB CEN16LA167Accident · No injuriesLimited investigationFinal reportProbst Zenair 601XL · Hempstead, TXA loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.Apr 24, 2016 · C-GXLP · Substantial damageNTSB CEN16LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brimfield, ILA loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Apr 23, 2016 · N7614X · Substantial damageNTSB WPR16LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Selma, CAThe total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.Apr 19, 2016 · N9909B · Substantial damageNTSB ERA16LA166Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tannersville, PAA loss of engine power for reasons that could not be determined based on the available evidence.Apr 19, 2016 · N5094X · Substantial damageNTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaApr 18, 2016 · RA-06233 · Substantial damageNTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.Apr 18, 2016 · N151DC · Substantial damageNTSB ENG16RA028Incident · No injuriesForeign investigationBombardier CL600 2C10 · Fukuoka, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving a Bombardier CL-600-2C10, JA06RJ, which took off from Fukuoka Airport at 07:48 local time to Komatsu Airport and during return back to Fukuoka Airport due to weather condition of…Apr 17, 2016 · JA06RJ · No damageNTSB ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.Apr 16, 2016 · N588TA · Substantial damageNTSB ERA16LA158Accident · No injuriesLimited investigationFinal reportCessna U206 · Atlantic Ocean (Atlantic Ocean)A total loss of engine power for reason(s) that could not be determined because the airplane was not recovered.Apr 15, 2016 · N1346Q · Substantial damageNTSB GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.Apr 14, 2016 · N958HP · Substantial damageNTSB ERA16LA157Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 175 · Wartburg, TNCatastrophic engine failure due to a fatigue fracture of the No. 6 connecting rod cap.Apr 14, 2016 · N6792E · Substantial damageNTSB ANC16WA018Accident · 2 fatalForeign investigationRockwell 112 · Revelstoke, CanadaOn April 11, 2016, about 2000 Coordinated Universal Time, a Rockwell Commander 112B airplane, CGQJN, impacted terrain near Revelstoke, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation…Apr 11, 2016 · C-GQJN · DestroyedNTSB DCA16WA138Incident · No injuriesForeign investigationBoeing 737 · Chiang Mai, ThailandMinistry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…Apr 10, 2016 · HS-LTB · No damageNTSB CEN16LA151Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Caldwell, TXThe failure of the No. 5 cylinder's exhaust pipe for undetermined reasons, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s fast and long landing, which led to a runway overrun.Apr 10, 2016 · N8PY · Substantial damageNTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…Apr 9, 2016 · EC-LQF · No damageNTSB ANC16FA017Accident · 3 fatalField investigationFinal reportCessna 206 · Angoon, AKThe pilot's inadvertent turn toward terrain that was higher-than-expected while trying to avoid poor visibility conditions and his subsequent attempt to clear terrain, which reduced the airspeed and led to the exceedance of the airplane's critical angle of…Apr 8, 2016 · N50159 · Substantial damageNTSB CEN16LA401Accident · No injuriesLimited investigationFinal reportAgustawestland Philadelphia AW139 · Galliano, LAThe fatigue failure of a tail rotor blade erosion shield extension, which resulted in in-flight damage to a main rotor blade.Apr 7, 2016 · N639NA · Substantial damageNTSB CEN16WA150Incident · No injuriesForeign investigationRobinson R22 Beta · Bern, SwitzerlandOn April 6, 2016, about 1330 Universal Coordinated Time (UTC), the crew of a Robinson R22 BETA, Swiss registration HB-ZGO, made a precautionary landing at Bern Airport (LSZB), Bern, Switzerland, after they smelled smoke. They noted the alternator had failed…Apr 6, 2016 · HB-ZGO · Minor damageNTSB GAA16CA177Accident · Minor injuriesData collectionFinal reportBeech A23 · Hulbert, OKThe pilot's inadequate fuel planning, which resulted in fuel exhaustion, and collision with terrain.Apr 5, 2016 · N5791V · Substantial damageNTSB OPS16IA010IncidentClass 3 · IncidentFinal reportMooney M20R · Jacksonville, FLThe air traffic controller's decision to issue climb instruction to one aircraft without ensuring the required separation with another could be maintained. Contributing to the incident was the air traffic controller's failure to issue a safety alert in a…Apr 3, 2016 · N57GX · 2 aircraft · No damageNTSB WPR16FA091Accident · 1 fatalField investigationFinal reportNokes Matthew Lancair IV P · Fallbrook, CAA loss of engine power during cruise for reasons that could not be determined because examination of the airplane did not reveal any anomalies that would have precluded normal operation.Apr 2, 2016 · N438Y · Substantial damageNTSB ERA16LA153Accident · Minor injuriesLimited investigationFinal reportButterhof Anthony J Ginny B · South Harrison Township, NJThe pilot/mechanic's failure to safety-wire the gascolator bale clamp, which resulted in a fuel leak and subsequent total loss of engine power.Apr 2, 2016 · N349E · Substantial damageNTSB ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…Apr 2, 2016 · N8115T · Substantial damageNTSB CEN16WA144Accident · 3 fatalForeign investigationCessna 208 · Tayoltita, Dgo, Mexico, MexicoOn April 1, 2016, about 0900 local time, a Cessna 208B single engine airplane, serial number 208B2104, registry XA-ULU, was substantially damaged during an off-airport forced landing near Tayoltita, San Dimas, Durango, Mexico. There were ten persons on-board…Apr 1, 2016 · XA-ULU · Substantial damageNTSB CEN16WA141Accident · 3 fatalForeign investigationCessna 172 · Madrid, SpainOn March 31, 2016, about 1200 coordinated universal time (UTC), a Cessna 172 airplane, Spanish registration EC-JSM, collided with the terrain following a bird strike near Madrid, Spain. The pilot and two passengers sustained fatal injuries, and the airplane…Mar 31, 2016 · EC-JSM · Substantial damageNTSB CEN16LA133Accident · Serious injuriesLimited investigationFinal reportMathieu Cassutt · Louisville, NEThe pilot's decision to operate with partial carburetor heat while operating in conditions conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing.Mar 28, 2016 · N78RM · Substantial damageNTSB ERA16LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-250 · Danville, VAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Mar 27, 2016 · N22AM · Substantial damageNTSB ERA16FA143Accident · 1 fatalField investigationFinal reportRobinson R44 · Canadensis, PAThe pilot's loss of control due to spatial disorientation, which occurred after ascending in order to clear rising terrain and inadvertently entering the clouds.Mar 27, 2016 · N776JM · DestroyedNTSB DCA16WA135Incident · No injuriesForeign investigationBoeing 737-76N · Porto de Moz Municipality, BrazilThe Brazil Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an accident involving a Boeing 737-76N that occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's…Mar 27, 2016 · PR-GOV · No damageNTSB CEN16WA140Accident · 2 fatalForeign investigationCessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, GuatemalaOn March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…Mar 27, 2016 · TG-KAM · Substantial damageNTSB WPR16LA090Accident · No injuriesLimited investigationFinal reportCessna 172L · McNeil Island, WAThe student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.Mar 26, 2016 · N1151M · Substantial damageNTSB CEN16LA134Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA 1B · Stephenville, TXThe loss of engine power during cruise flight due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning and in-flight fuel management.Mar 26, 2016 · N8883L · Substantial damageNTSB ERA16WA147Accident · 3 fatalForeign investigationBell 206 · Riosucio, Choco, ColombiaMar 22, 2016 · HK-5049 · Substantial damageNTSB ERA16WA138Accident · 3 fatalForeign investigationBell 206B III · Angostura, ColombiaOn March 23, 2016, about 1211 universal coordinated time, a Bell 206B III, Colombian registration HK4764, was destroyed when it impacted mountainous terrain and was consumed by a postcrash fire. Three of the four occupants were fatally injured, and one…Mar 22, 2016 · HK4674 · DestroyedNTSB DCA16CA181Accident · Serious injuriesData collectionFinal reportBoeing 737 724 · Port Arthur, TXan inadvertent encounter with clear air turbulence.Mar 15, 2016 · N23708 · No damageNTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…Mar 12, 2016 · N838RV · Substantial damageNTSB DCA16WA122Incident · No injuriesForeign investigationBoeing 737 · Malaga, SpainThe government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…Mar 12, 2016 · LN-NHG · No damageNTSB ERA16WA132Incident · No injuriesForeign investigationLearjet 60 · Doha, QatarOn March 9, 2016, about 1800 universal coordinated time, a Learjet 60 XR, United Arab Emirates registration A6RJE, incurred minor damage during cruise flight near Hamad International Airport (OTHH), Doha, Qatar. The two pilots, one flight attendant and four…Mar 9, 2016 · A6RJE · Minor damageNTSB DCA16WA104Incident · No injuriesForeign investigationBoeing 747 · Jeddah, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on March 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…Mar 9, 2016 · TF-AMU · No damageNTSB ERA16LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hauppauge, NYThe total loss of engine power, which resulted from the failure of the camshaft gear due to fatigue. Contributing to the accident was the owner/operator's failure to comply with the engine manufacturer's recommended overhaul interval.Mar 5, 2016 · N295AR · Substantial damageNTSB ERA16LA123Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BL · St. Petersburg, FLA partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.Mar 5, 2016 · N22661 · Substantial damageNTSB ENG16RA026Incident · No injuriesForeign investigationCessna 208 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Cessna 208B, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…Mar 3, 2016 · 8R-GHT · No damageNTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.Mar 2, 2016 · N568TB · Substantial damageNTSB CEN16LA118Accident · No injuriesLimited investigationFinal reportCessna 150G · Simmesport, LAThe installation of an improper bearing and thrust washer during engine overhaul, which resulted in failure of the connecting rods and a subsequent total loss of engine power.Mar 2, 2016 · N3339J · Substantial damageNTSB CEN16FA116Accident · 2 fatalField investigationFinal reportCurtiss Wright Travel AIR 4000 · Palmer Lake, COThe pilot's failure to maintain sufficient airspeed while maneuvering at low altitude in strong gusting winds, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's…Mar 2, 2016 · N6464 · DestroyedNTSB CEN16LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Laguna Pueblo, NMA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.Feb 29, 2016 · N2711M · Substantial damage