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 DCA18CA316Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · West Palm Beach, FLAn inadvertent encounter with convective turbulence.Jul 23, 2018 · N328NB · No damageNTSB DCA18CA251Accident · Serious injuriesClass 4 · Data collectionFinal reportMcdonnell Douglas MD88 · Charlotte, NCAn inadvertent encounter with convective turbulence.Jul 23, 2018 · N918DE · No damageNTSB CEN18LA287Accident · No injuriesLimited investigationFinal reportCessna 210C · Blum, TXThe pilot's excessive leaning of the fuel mixture, which resulted in a loss of engine power, and the pilot's failure to extend the landing gear in accordance with the airplane emergency checklist, which resulted in a gear-up landing.Jul 21, 2018 · N3611Y · Substantial damageNTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…Jul 19, 2018 · N70DD · Substantial damageNTSB CEN18LA284Accident · No injuriesLimited investigationFinal reportToomey Quickie · Zanesville, OHThe failure of the exhaust manifold and a loose mixture screw, which resulted in a partial loss of engine power.Jul 19, 2018 · N23JH · Substantial damageNTSB CEN18FA282Accident · 1 fatalField investigationFinal reportFisher Celebrity · Patriot, INAn in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.Jul 19, 2018 · N228LC · DestroyedNTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.Jul 17, 2018 · N16281 · 2 aircraft · DestroyedNTSB CEN18LA276Accident · No injuriesLimited investigationFinal reportBeech V35 · Katy, TXMaintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.Jul 17, 2018 · N228Q · Substantial damageNTSB DCA18WA243Incident · No injuriesForeign investigationBoeing 737 · Frankfurt, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…Jul 13, 2018 · EI-ENMNTSB WPR18LA197Accident · No injuriesClass 3 · LimitedFinal reportBeech 90 · Tolani Lake, AZAn autopilot deviation during climb for undetermined reasons, which resulted in an in-flight upset and loss of airplane control. Contributing to the accident was the pilot’s failure to adequately monitor flight systems due to a distraction.Jul 12, 2018 · N617MM · Substantial damageNTSB ERA18WA216Incident · No injuriesForeign investigationCessna 501 · Catamarca, ArgentinaThe government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…Jul 12, 2018 · LV-CGO · Minor damageNTSB DCA18WA232IncidentClass 5 · ForeignBoeing 737 · Multan, PakistanJul 12, 2018 · A6-FGB · No damageNTSB CEN18LA275Accident · No injuriesLimited investigationFinal reportWhittman Tailwind · Orient, OHThe pilot’s and the flight instructor's incorrect use of the modified mixture control, which resulted in a loss of engine power due to fuel starvation and a forced landing. Also causal was the inadequate systems knowledge of the experimental, amateur-built…Jul 12, 2018 · N619NT · Substantial damageNTSB WPR18TA192Accident · Serious injuriesFinal reportSchempp Hirth Discus CS · Goldfield, NVThe glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.Jul 11, 2018 · N104TH · Substantial damageNTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 11, 2018 · N2394G · Substantial damageNTSB ERA18LA190Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Passadumkeag, MEA total loss of engine power due to a fatigue fracture of the crankshaft.Jul 11, 2018 · N352GL · Substantial damageNTSB DCA18WA247Incident · No injuriesForeign investigationDouglas DC9 · Chichen Itza, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…Jul 11, 2018 · N802WA · No damageNTSB ANC18FA053Accident · Serious injuriesField investigationFinal reportDe Havilland DHC 3 · Hydaburg, AKThe pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jul 10, 2018 · N3952B · Substantial damageNTSB ERA18FA187Accident · 2 fatalField investigationFinal reportRobinson R44 · Williamsburg, VAThe pilot's failure to safely operate the helicopter due to his impaired cognitive and physical abilities, which resulted in a loss of control.Jul 8, 2018 · N616HS · DestroyedNTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…Jul 8, 2018 · N312SA · Substantial damageNTSB GAA18CA431Accident · Minor injuriesData collectionFinal reportCessna 172 · King and Queen, VAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jul 5, 2018 · N1401F · Substantial damageNTSB CEN18WA327Accident · No injuriesForeign investigationColumbia LC41-550FG · Vallecillos, MexicoOn July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…Jul 4, 2018 · XB-OHG · Substantial damageNTSB GAA18CA392Accident · No injuriesData collectionFinal reportSchempp Hirth Discus CS · Pomfret, VTThe glider pilot’s selection of an unsuitable landing area, which resulted in a collision with a ditch during the landing roll.Jul 3, 2018 · N1122Q · Substantial damageNTSB DCA18WA246Incident · No injuriesForeign investigationBoeing 737 300 · Nassau, BahamasThe Air Accident Investigation Department (AAID) - Ministry of Tourism, Aviation & Bahamasair has notified the NTSB of an incident involving a Boeing 737 300 airplane that occurred on July 03, 2018. The NTSB has appointed a U.S. Accredited Representative to…Jul 3, 2018 · N331CK · No damageNTSB CEN18LA247Accident · Serious injuriesLimited investigationFinal reportSafari 400 · Aguilares, TXThe loss of tail rotor control due to the in-flight failure of the tail rotor pinion.Jul 2, 2018 · N326RW · Substantial damageNTSB GAA18CA419Accident · No injuriesData collectionFinal reportCessna 152 · Panama City, FLThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Jun 30, 2018 · N89887 · Substantial damageNTSB ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.Jun 30, 2018 · N10CV · Substantial damageNTSB CEN18WA254Accident · No injuriesForeign investigationBritten Norman BN2A · Ambergris Caye, BelizeJun 30, 2018 · V3-HFB · Substantial damageNTSB WPR18LA194Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Salisbury, NCA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available information.Jun 29, 2018 · N8440F · Substantial damageNTSB DCA18WA238Incident · Minor injuriesForeign investigationAirbus A330 · Gander, CanadaThe government of Canada has notified the NTSB of an accident involving a Airbus A330 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…Jun 29, 2018 · N278AY · No damageNTSB ERA18WA272Accident · 1 fatalForeign investigationCessna 172 · Adiyaman, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…Jun 27, 2018 · TC-GUB · DestroyedNTSB GAA18CA377Accident · No injuriesData collectionFinal reportJonker Sailplanes JS1-C · Panguitch, UTThe pilot’s inability to maintain altitude and his delayed decision to deploy the powered-glider’s engine, which necessitated an off-airport landing.Jun 24, 2018 · N963CG · Substantial damageNTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 24, 2018 · N19MM · DestroyedNTSB ANC18FA050Accident · 2 fatalField investigationFinal reportPiper PA 18-150 · Delta Junction, AKUndetermined based on the available evidence.Jun 24, 2018 · N8664Y · Substantial damageNTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.Jun 19, 2018 · N764CT · DestroyedNTSB DCA18CA255Accident · Serious injuriesData collectionFinal reportEmbraer ERJ175 · Cut Bank, MTan unexpected encounter with clear air turbulence.Jun 17, 2018 · N637CZ · No damageNTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.Jun 17, 2018 · N6107R · Substantial damageNTSB ERA18WA237Accident · 2 fatalForeign investigationAgusta A109 · Espírito Santo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta A109 helicopter that occurred on June 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Jun 16, 2018 · PR-JMB · DestroyedNTSB CEN18LA225Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Cheyenne, WYA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 14, 2018 · N4954W · Substantial damageNTSB ERA18FA167Accident · 2 fatalField investigationFinal reportRaytheon 58 · Springfield Township, NJA loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.Jun 13, 2018 · N218BL · DestroyedNTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.Jun 13, 2018 · N9423B · 2 aircraft · Substantial damageNTSB DCA18WA207Incident · No injuriesForeign investigationBoeing 737 · Otopeni, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…Jun 12, 2018 · YR-BGG · No damageNTSB DCA18CA219Accident · Serious injuriesData collectionFinal reportBoeing 787-9 · Harbin, Chinathe accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.Jun 11, 2018 · N826AN · No damageNTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.Jun 7, 2018 · N7765X · Substantial damageNTSB ERA18LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Fort Morgan, ALA partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 7, 2018 · N755KT · Substantial damageNTSB CEN18LA213Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Uvalde, TXThe loose oil filter, which resulted in oil starvation and a total loss of engine power in flight.Jun 7, 2018 · N3291X · DestroyedNTSB WPR18WA165Accident · 10 fatalForeign investigationCessna 208 · Njabini, KenyaOn June 5, 2018, about 1705 local time, a Cessna 208, 5Y-CAC, collided into a mountain in the Aberdare mountain range near Njabini, Kenya. The 2 pilots and 8 passengers were fatally injured; the airplane was destroyed. The airplane was owned and operated by…Jun 5, 2018 · 5Y-CAC · DestroyedNTSB CEN18LA207Accident · No injuriesLimited investigationFinal reportCessna T210 · Clovis, NMThe total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.Jun 3, 2018 · N66ML · Substantial damageNTSB ERA18LA157Accident · 4 fatalLimited investigationFinal reportPiper PA 31 · Amagansett, NYThe pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.Jun 2, 2018 · N41173 · DestroyedNTSB CEN18LA209Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Longview, TXThe pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…Jun 1, 2018 · N72066 · Substantial damage