NTSB investigations, 2018
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WHERE year(c.\"eventDate\") = 2018 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 WHERE year(c."eventDate") = 2018 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 ERA19WA058Accident · 4 fatalForeign investigationCessna 525 · Jequitaí County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ENG19WA005Incident · No injuriesForeign investigationBoeing 767 · Addis Ababa, EthiopiaOn November 26, 2018, a Boeing 767-300 airplane, operated by Ethiopian Airlines, experienced a right engine (No. 2) fan blade failure during takeoff from the Addis Ababa Bole International Airport (ADD), Ethiopia. The airplane returned to ADD where an…NTSB GAA19CA073Accident · No injuriesData collectionFinal reportBeech C23 · Porterville, CAThe pilot's improper landing flare, which resulted in an abnormal landing and subsequent porpoise.NTSB DCA19WA068Incident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB WPR19WA032Accident · 1 fatalForeign investigationRobinson R22 · Alice Springs, AustraliaOn November 24, 2018, at 1200 local time, a Robinson R22 BETA, VH-KZV, collided with terrain near Alice Springs, NT, Australia. The helicopter sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight…NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB ERA19WA104Accident · 6 fatalForeign investigationAgusta AW109 · Campos do Jordao, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB WPR19WA081Accident · 5 fatalForeign investigationCessna U206 · Chemajenjera Hill, ZimbabweOn November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…NTSB GAA19CA094Accident · No injuriesData collectionFinal reportCirrus SR22 · Greenville, SCThe pilot's improper landing flare with a gusting, right quartering headwind, which resulted in a hard landing.NTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.NTSB ERA19TA067Accident · No injuriesClass 3Final reportBeech A36 · Summerland Key, FLThe pilot’s inadvertent retraction of the landing gear during landing rollout, resulting in a landing gear collapse.NTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.NTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB ERA19WA054Accident · 5 fatalForeign investigationEurocopter EC120 · La Romana, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB DCA19WA026Incident · No injuriesForeign investigationBoeing 737 · La Paz, BoliviaThe AIG of Bolivia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Bolivia's investigation under the provisions of ICAO Annex…NTSB GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.NTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.NTSB ERA19WA053Accident · 2 fatalClass 5 · ForeignCessna TU206 · Puente Alto, ChileNTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…NTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.NTSB WPR19LA029Accident · No injuriesClass 3 · LimitedFinal reportBKF Backcountry Supercub · Casper, WYThe seizure of two bearings in the reduction gearbox, resulting in the total loss of engine power. Contributing to the accident was a high descent rate which resulted in a hard landing.NTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.NTSB ERA19WA075Accident · 2 fatalForeign investigationCessna 172 · Denizli, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA19CA063Accident · No injuriesData collectionFinal reportRobinson R44 · Knox City, TXThe pilot's failure to maintain adequate airspeed with a tailwind, which resulted in the helicopter settling with power, and his subsequent incorrect collective application while attempting to recover, which resulted in a loss of helicopter control due to a…NTSB ERA19LA086Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Petersburg, WVA loss of control during the landing roll and subsequent runway excursion for reasons that could not be determined based on the available evidence.NTSB CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.NTSB WPR19TA037Accident · Minor injuriesClass 3Final reportScottish Series 100 MDL 101 · Lake Pleasant, AZImpact with a lake for undetermined reasons.NTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.NTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.NTSB ERA19LA050Accident · Minor injuriesClass 3 · LimitedFinal reportUltralite Sro Stingsport · Clermont, FLAn inflight failure of the airplane’s horizontal stabilizer.NTSB ERA19FA049Accident · 1 fatalClass 2 · FieldFinal reportLancair Legacy RG · Gainesville, GAThe pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…NTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…NTSB DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…NTSB CEN19FA028Accident · 2 fatalField investigationFinal reportNorth American P51 · Fredericksburg, TXThe pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.NTSB WPR19FA026Accident · 2 fatalClass 2 · FieldFinal reportZenith CH601 · Overgaard, AZThe pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.NTSB WPR19FA025Accident · 2 fatalClass 2 · FieldFinal reportCessna 182 · Redding, CAThe pilot's spatial disorientation and subsequent loss of control after takeoff in dark night instrument meteorological conditions.NTSB GAA19CA064Accident · No injuriesData collectionFinal reportCessna 182 · Charlotte, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA19TA051Accident · Minor injuriesFinal reportCessna E162 · Franklin, NCThe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.NTSB ERA19FA047Accident · 2 fatalClass 2 · FieldFinal reportBell OH 58C · Verbena, ALThe pilot's improper decision to conduct a low-level flight over a river, and his failure to see and avoid power lines, which resulted in the helicopter's impact with power lines and the water.NTSB WPR19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Presidio, TXThe student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.NTSB GAA19CA060Accident · Minor injuriesData collectionFinal reportBeech 36 · Williams, AZThe pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.NTSB ERA19WA045Accident · No injuriesForeign investigationPiper PA25 · Ezperanza, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…NTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.NTSB GAA19CA056Accident · No injuriesData collectionFinal reportGuimbal Cabri · Newberg, ORThe pilot under instruction's failure to maintain directional control and the flight instructor's delayed remedial action.NTSB DCA19WA224Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Hong Kong, ChinaNTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.NTSB GAA19CA058Accident · Minor injuriesData collectionFinal reportCessna 172 · Piseco, NYThe pilot’s loss of directional control during landing, which resulted in impact with a snow pile and necessitated a go-around, during which the airplane impacted trees.