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 CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.NTSB ANC18FA063Accident · 5 fatalField investigationFinal reportDe Havilland DHC-2 · Talkeetna, AKImpact with terrain for reasons that could not be determined because the airplane was not recovered due to the inaccessible nature of the accident site.NTSB GAA18CA502Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Dansville, NYThe pilot’s failure to maintain clearance from crops during an agricultural application flight.NTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.NTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.NTSB GAA18CA471Accident · Minor injuriesData collectionFinal reportCessna 172 · Dowagiac, MIThe pilot's failure to maintain bank control during takeoff.NTSB GAA18CA469Accident · Minor injuriesData collectionFinal reportRans S7 · Kenai, AKThe pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB ERA18LA210Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.NTSB ERA18FA208Accident · 2 fatalField investigationFinal reportChampion 8GCBC · Foley, ALThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.NTSB CEN18WA312Accident · 1 fatalForeign investigationSteen Skybolt · Fratauti, RomaniaNTSB CEN18LA319Accident · No injuriesLimited investigationFinal reportBeech 35 · Knox, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA310Accident · 5 fatalClass 3 · FieldFinal reportExtra EA 400 · Ponca City, OKThe pilot's loss of control for reasons that could not be determined with the available evidence.NTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.NTSB CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.NTSB CEN18LA314Accident · Serious injuriesLimited investigationFinal reportAirbus EC 130 T2 · Mullen, NEThe pilot’s inadequate and incorrect antitorque pedal application during a tight, decelerating turn downwind, which resulted in a loss of yaw control.NTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB CEN18WA394Accident · No injuriesForeign investigationPiper PA28 · Décines, FranceOn August 2, 2018, about 1930 UTC, a Piper PA-28-181 airplane, French registration F-GKEC, sustained a loss of engine power while on approach to the Lyon-Bron Airport (LFLY), near Décines, France. The two occupants onboard sustained no injury. The airplane…NTSB CEN18LA311Accident · No injuriesLimited investigationFinal reportCessna 188 · Watkins, MNA partial loss of engine power for reasons that could not be determined because a postaccident examination revealed no evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA307Accident · No injuriesLimited investigationFinal reportGerald Dan Coppock Bade-E · Escanaba, MIThe loss of control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in a ground loop and runway excursion.NTSB CEN18LA306Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 3B · Custer, SDThe pilot’s mismanagement of rotor RPM and subsequent forced landing on uneven terrain which led to a dynamic rollover.NTSB WPR18LA216Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Creek, IDThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA521Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Fairbanks, AKThe pilot’s premature liftoff and subsequent settling of the airplane to the gravel airstrip.NTSB GAA18CA475Accident · No injuriesData collectionFinal reportBeech B300 · Wilmington, NCThe airplane’s collision with a bird during approach.NTSB DCA18WA258Incident · No injuriesForeign investigationBoeing 737 · Pardubice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB CEN18WA372Accident · No injuriesForeign investigationRobinson R22 · Naunton Beauchamp, Worcestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB CEN18WA343Accident · 1 fatalForeign investigationPiper PA25 · Namiquipa, MexicoOn August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…NTSB ANC18WA062Accident · 2 fatalForeign investigationCessna 180 · Gold Bridge, CanadaOn August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…NTSB ANC18WA061Accident · 2 fatalForeign investigationPiper PA-31 · Calgary, CanadaOn August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…NTSB ANC18LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · White Mountain, AKA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.NTSB DCA18RA253Accident · Serious injuriesForeign investigationEmbraer ERJ190 · Durango, MexicoThe Director General of Civil Aviation (DGAC) of Mexico has notified the NTSB of an accident involving an Embraer E-190, which occurred on July 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB DCA18CA266Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Philadelphia, PAThe captain's improper control of the airplane during the landing flare.NTSB CEN18LA303Accident · Minor injuriesLimited investigationFinal reportBuchanan Kitfox IV · Loma, COThe pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.NTSB GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.NTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.NTSB ERA18FA206Accident · 3 fatalField investigationFinal reportPiper PA60 · Greenville, METhe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.NTSB CEN18WA304Accident · 1 fatalForeign investigationQuad City Challenger · North Bay, CanadaOn July 30, 2018, about 1500 Coordinated Universal Time, a Quad City Challenger II airplane, Canadian registration C-IGKT, crashed near Talon Lake, North Bay, Ontario, Canada. The pilot was fatally injured. The flight departed North Bay (CYYB), Ontario, and…NTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.NTSB ANC18WA075Accident · 1 fatalForeign investigationPiper PA28 · Black Diamond, CanadaOn July 30, 2018, about 0133 Coordinated Universal Time, a Piper PA-28-161 airplane, C-GVZJ, was departing a cut hay field and collided with hay bales near Black Diamond, Alberta, Canada, under unknown circumstances. Of the two occupants onboard, 1 sustained…NTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.NTSB GAA18CA460Accident · No injuriesData collectionFinal reportCessna 172 · Grand Prairie, TXThe student pilot’s failure to maintain the runway centerline during takeoff with a crosswind.NTSB ERA18WA209Accident · 1 fatalForeign investigationBeech 90 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech C90 that occurred on July 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO Annex…NTSB ERA18LA204Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Haverhill, NHThe pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.NTSB CEN18LA298Accident · Minor injuriesLimited investigationFinal reportExtra EA300 · North Fox Island, MIThe Extra pilot’s failure to see and avoid the Cessna, which resulted in an in-flight collision. Contributing to the accident was the failure of the Extra pilot to tune his radio to the correct frequency, which resulted in no common traffic advisories being…NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.