NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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 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.
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 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR16FA084Accident · 4 fatalField investigationFinal reportCessna 182A · Alpine, WYThe noninstrument-rated pilot's failure to maintain airspeed during the initial climb in dark night conditions with no visual reference, which resulted in a stall and collision with terrain.NTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.NTSB ERA16CA128Accident · Serious injuriesData collectionFinal reportCessna 180 · South Burlington, VTThe pilot's failure to maintain airplane control during takeoff roll, which resulted in a nose over.NTSB ENG16RA011Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…NTSB WPR16LA082Accident · No injuriesLimited investigationFinal reportGrumman G164 · Juliaetta, IDA partial loss of engine power due to a crack in the No. 2 cylinder.NTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.NTSB GAA16CA149Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · Brigham City, UTLoss of directional control during landing, due to nose landing gear damage sustained in the prior takeoff, resulting in a runway excursion and nose over.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB 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…NTSB 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…NTSB CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…NTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.NTSB CEN16FA122Accident · 2 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Española, NMThe pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.NTSB WPR16LA088Accident · No injuriesLimited investigationFinal reportThomas D. Parkes Lancair ES · Prescott, AZA partial loss of engine power due to an over-temperature event, which thermally damaged the blade tips of the turbocharger wheel and resulted in a slowing or stoppage in the rotation of the turbocharger.NTSB ENG16WA009Incident · No injuriesForeign investigationZurich, SwitzerlandOn March 10, 2016, about 1611 UTC, a Swiss Global Air Lines AVRO 146-RJ100 airplane, Swiss registration HB-IYT, rejected its takeoff at Zurich, Switzerland at 45 knots because of sparks coming from the No. 2 engine. The investigation of this incident is under…NTSB GAA16CA148Accident · No injuriesData collectionFinal reportRemos G 3/600 · Chesapeake, OHThe pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.NTSB 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…NTSB ERA16LA126Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20 · Pottstown, PAThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.NTSB 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…NTSB ERA16WA339Accident · 2 fatalForeign investigationPiper PA28 · Johannesburg, South AfricaOn March 7, 2016, about 1410 coordinated universal time, Piper PA28-140, South African registration ZS-EXV, was destroyed when it impacted terrain during an emergency landing to Mountain View Airfield (FAMV), Johannesburg, South Africa. The pilot and a…NTSB GAA16CA187Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe failure of the student pilot to maintain pitch control while landing, which resulted in a hard landing, loss of directional control, and runway excursion.NTSB ERA16CA125Accident · No injuriesData collectionFinal reportPiper PA 22-108 · Lincolnton, NCThe non-certificated pilot's loss of directional control while landing.NTSB WPR16LA080Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache · Queen Creek, AZA loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…NTSB GAA16CA145Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Canton, TXThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and a collision with trees.NTSB 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.NTSB 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.NTSB DCA16WA111Incident · No injuriesForeign investigationBoeing 737 · Billund, DenmarkThe Turkish Directorate General of Civil Aviation (DGCA) has notified the NTSB of an accident involving a Boeing 737 that occurred on March 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA of Turkey's investigation under…NTSB DCA16CA113Accident · No injuriesData collectionFinal reportBoeing 767 34AF · Albuquerque, NMthe pilot flying's failure to maintain airspeed and correct pitch attitude. Contributing to the accident was the pilot's failure to maintain appropriate thrust after disconnecting the autothrottles. Also contributing was the first officer's failure to monitor…NTSB CEN16LA121Accident · Serious injuriesLimited investigationFinal reportAriosto James J Ariosto Mustang II · Normangee, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.NTSB 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…NTSB ENG16RA017Accident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Jet Airways Boeing 737, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation…NTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA078Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Palm Springs, CAImproper assembly of a fuel hose, which restricted the fuel supply to the carburetor and resulted in a loss of engine power during the initial climb after takeoff.NTSB GAA16CA144Accident · No injuriesData collectionFinal reportCessna 195 · Clinton, ARThe pilot's failure to maintain direction control during the landing roll, which resulted in runway excursion, and collision with a fence.NTSB 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.NTSB ERA16LA137Accident · No injuriesLimited investigationFinal reportBeech 99 · Rockland, METhe airplane’s encounter with isolated severe turbulence, which resulted in substantial airframe damage.NTSB 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.NTSB 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…NTSB GAA16CA142Accident · No injuriesData collectionFinal reportMaule M5 · Wasilla, AKThe student pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, and an impact with terrain.NTSB ERA16LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Chester, CTThe pilot’s failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ERA16LA121Accident · No injuriesLimited investigationFinal reportPiper PA46 · Brunswick, GAA hard landing, which resulted in the collapse of the nose gear assembly due to an overstress fracture and separation of the right side mounting point.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…NTSB 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.NTSB ERA16LA120Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Atlanta, GAA total loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.NTSB ERA16LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Gainesville, FLThe failure of the engine crankshaft near the Nos. 4 and 5 crankshaft journals due to oil starvation. The reason for the oil starvation could not be determined during postaccident examination.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),…NTSB CEN16FA111Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Navasota, TXThe flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…NTSB ANC16WA015Accident · 2 fatalForeign investigationCessna 172 · Seoul, South KoreaOn February 28, 2016 , about 1831 Local Time, a Cessna 172S airplane, Republic of Korea registration number HL1153, operated by the pilot, was destroyed following a loss of control shortly after takeoff from Gimbo International Airport, Republic of Korea.…NTSB WPR16WA085Accident · 1 fatalForeign investigationZlin Z242L · Hong Kong, Hong Kong SAR ChinaOn February 27, 2016, approximately 0610 coordinated universal time (UTC), a Zlin Z242L, Hong Kong registration B-LUR, was substantially damaged when it impacted the water under unknown circumstances near the Tolo Harbour, Tai Po, Hong Kong. The pilot, the…NTSB ERA16LA116Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAA partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.