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 WPR19LA273Accident · No injuriesClass 3 · LimitedFinal reportSmyth Sidewinder · Tucumcari, NMThe in-flight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.Sep 14, 2019 · N492AC · Substantial damageNTSB CEN19LA331Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR20 · Orange, TXA total loss of engine power due to a fatigue failure of the fuel line from the fuel manifold to the No. 1 cylinder.Sep 14, 2019 · N200Z · Substantial damageNTSB CEN19LA320Accident · Minor injuriesClass 2 · LimitedFinal reportCirrus SR22 · Hoagland, INA catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance…Sep 13, 2019 · N578SP · Substantial damageNTSB WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.Sep 11, 2019 · N1168U · Substantial damageNTSB DCA19WA216Incident · No injuriesForeign investigationAirbus A321 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Airbus A321 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Sep 11, 2019 · N958JB · No damageNTSB GAA19WA553Accident · 1 fatalForeign investigationCessna 208 · Gransee, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…Sep 9, 2019 · D-FIDI · DestroyedNTSB CEN19LA308Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Whitehall, MIThe pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation.Sep 9, 2019 · N9492U · DestroyedNTSB WPR19FA256Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · La Grande, ORThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Sep 8, 2019 · N6300Z · DestroyedNTSB CEN19FA307Accident · 2 fatalClass 3 · FieldFinal reportCessna 140 · Lakeview, SDThe student pilot’s failure to maintain control of the airplane, which resulted in the exceedance of the airplane’s critical angle-of-attack, an aerodynamic stall, and subsequent impact with terrain, and the student pilot’s non-compliance and lack of…Sep 8, 2019 · N73000 · Substantial damageNTSB CEN19FA305Accident · 1 fatalClass 3 · FieldFinal reportChampion 7GCBC · Carpenter, WYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.Sep 7, 2019 · N5502S · DestroyedNTSB DCA19CA213Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Fort Myers, FLan encounter with convectively induced turbulence associated with towering cumulus clouds during descent.Sep 6, 2019 · N515NK · No damageNTSB GAA19WA593Accident · No injuriesForeign investigationPiper PA25 · Mazatan, Chiapas, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Sep 5, 2019 · XB-LEDNTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…Sep 5, 2019 · C-GSEN · DestroyedNTSB CEN19LA303Accident · No injuriesClass 3 · LimitedFinal reportPhantom Aeronautics X-1 · Van Wert, OHA loss of engine power due to the separation of the carburetor from the intake socket resulting from the improper installation of the intake silencer.Sep 4, 2019 · N111JC · Substantial damageNTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…Sep 3, 2019 · N2909U · Substantial damageNTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.Sep 3, 2019 · N2XF · Substantial damageNTSB DCA19WA212Incident · No injuriesForeign investigationBoeing 737 · South AfricaThe government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…Sep 2, 2019 · ZS-SJD · No damageNTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.Sep 2, 2019 · N405JA · Substantial damageNTSB ERA19LA264Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Foley, ALTotal loss of engine power due to a fatigue failure of the camshaft gear.Sep 1, 2019 · N878SR · Substantial damageNTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Aug 31, 2019 · LN-OFU · DestroyedNTSB ANC19LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18 · Fairbanks, AKThe inappropriate application of paint underneath the engine cylinder hold-down nuts, which resulted in inadequate torque and the subsequent in-flight separation of the No. 3 cylinder, and resulted in a total loss of engine power.Aug 30, 2019 · N1124 · Substantial damageNTSB WPR19WA260Accident · 1 fatalForeign investigationAir Tractor AT502 · Gusap, Papua New GuineaOn August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)…Aug 29, 2019 · P2-SET · DestroyedNTSB ENG19RA033Incident · No injuriesForeign investigationSaab 340 · Merimbula, AustraliaThe Australian Transport Safety Bureau (ATSB) notified the NTSB of an incident involving a SAAB 340B airplane which occurred on August 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…Aug 29, 2019 · VH-RXX · No damageNTSB DCA19CA206Accident · Serious injuriesData collectionFinal reportAirbus A320 · Denver, COan encounter with mountain wave turbulence.Aug 27, 2019 · N328FR · No damageNTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.Aug 27, 2019 · N6245V · Substantial damageNTSB WPR19LA240Accident · No injuriesClass 3 · LimitedFinal reportScoda Aeronautical Super Petrel · Lancaster, CAThe improper sealing of both carburetor bowls, which resulted in a total loss of engine power.Aug 25, 2019 · N632MM · Substantial damageNTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Aug 25, 2019 · PR-APN · DestroyedNTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Aug 25, 2019 · G-BVDH · DestroyedNTSB CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.Aug 25, 2019 · N49614 · Substantial damageNTSB DCA19WA209Incident · No injuriesForeign investigationBoeing 777 · Shannon, IrelandThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…Aug 24, 2019 · G-STBB · No damageNTSB ERA19LA258Accident · No injuriesClass 3 · LimitedFinal reportBeech F33 · Hobe Sound, FLA bearing shift, which resulted in a loss of lubrication to the crankshaft, the failure of the crankshaft, and a total loss of engine power.Aug 23, 2019 · N80WH · Substantial damageNTSB ERA19LA257Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Burnsville, NCThe pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…Aug 22, 2019 · N404PE · Substantial damageNTSB WPR19LA238Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Half Moon Bay, CAA total loss of engine power for reasons that could not be determined.Aug 21, 2019 · N134P · DestroyedNTSB ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.Aug 21, 2019 · N735D · Substantial damageNTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…Aug 20, 2019 · SX-HTO · Substantial damageNTSB ERA19LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 31P · East Brady, PAA total loss of left engine power for undetermined reasons.Aug 20, 2019 · N90AP · Substantial damageNTSB DCA19WA217Incident · No injuriesForeign investigationBoeing 737 · Cape Town, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of…Aug 20, 2019 · ZS-JRM · Minor damageNTSB ERA19FA251Accident · Serious injuriesField investigationFinal reportCirrus SR22 · Tappahannock, VAThe pilot's inability to land on the runway in dark night conditions with reported smoke in the cockpit, which necessitated the deployment of the airplane's parachute system.Aug 19, 2019 · N621JE · Substantial damageNTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.Aug 18, 2019 · N5364Q · DestroyedNTSB ERA19TA254Accident · Minor injuriesClass 3Final reportGIger Frank R Nieuport II · Talladega, ALA total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.Aug 17, 2019 · N112GV · Substantial damageNTSB ENG19WA032Incident · No injuriesForeign investigationAirbus A320 · Nassau, BahamasThe Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions…Aug 17, 2019 · N335NW · No damageNTSB CEN19WA341Accident · No injuriesForeign investigationCessna 150 · Ravna Gora, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions…Aug 17, 2019 · 9A-DMI · No damageNTSB GAA19CA495Accident · Minor injuriesData collectionFinal reportFlight Design CT2K · Hooper, WAThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, an off-airport landing to a field, and a subsequent nose-over.Aug 16, 2019 · N433CT · Substantial damageNTSB DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…Aug 15, 2019 · JA808A · No damageNTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.Aug 15, 2019 · N150CR · Substantial damageNTSB WPR19FA216Accident · 2 fatalClass 3 · FieldFinal reportLancair Lancair IV · Kooskia, IDThe pilot’s failure to maintain airspeed while maneuvering in an area of precipitation and reduced visibility, which resulted in an aerodynamic stall and spin and loss of airplane control.Aug 11, 2019 · N350CL · Substantial damageNTSB WPR21WA102AccidentClass 5 · ForeignCessna 150 · Gan International Airport, MaldivesAug 9, 2019 · 8Q-GAC · Minor damageNTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…Aug 9, 2019 · OO-JBM · DestroyedNTSB ENG19WA042Incident · No injuriesForeign investigationAirbus A320 · Varanasi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 9, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…Aug 9, 2019 · VT-IZT · No damageNTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…Aug 8, 2019 · N40702 · Substantial damage