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 CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.NTSB GAA17CA051Accident · No injuriesData collectionFinal reportCessna 152 · Chickaloon, AKThe flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.NTSB GAA17CA027Accident · Minor injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe airplane's encounter with a depression while the pilot applied excessive braking during the landing roll on a grass airstrip, which resulted in a nose-over.NTSB GAA17CA026Accident · Serious injuriesData collectionFinal reportPiper PA 28 · Latrobe, PAThe pilot’s unstabilized approach, which resulted in the airplane’s wing striking the ground while the pilot was maneuvering to realign with the runway.NTSB ERA17LA018Accident · 1 fatalLimited investigationFinal reportCessna 208 · Dunnellon, FLThe jumpmaster's failure to guard the reserve parachute ripcord, which caused an inadvertent deployment of his reserve parachute.NTSB ANC17WA030Accident · 4 fatalForeign investigationCessna 500 · Kelowna, CanadaOn October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft…NTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…NTSB ERA17LA014Accident · No injuriesLimited investigationFinal reportCessna 525 · Pawtucket, RIThe flight crew's failure to maintain an appropriate approach speed and obtain an appropriate touchdown point on the runway, which resulted in a runway overrun.NTSB DCA17WA010Accident · No injuriesForeign investigationPiper PA28 · Jozini, South AfricaThe government of South Africa has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on October 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB WPR17LA004Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell International 112A · Phoenix, AZA catastrophic engine failure due to lack of lubrication due to the absence of 2 piston cooling nozzles that backed out of their respective threaded bores, which resulted in a forced landing on unsuitable terrain.NTSB GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB GAA17CA020Accident · No injuriesData collectionFinal reportRemos Remos GX · Lowell, ARThe pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.NTSB ERA17FA011Accident · 1 fatalField investigationFinal reportPiper PA 34-200 · East Hartford, CTThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA17CA013Accident · Serious injuriesData collectionFinal reportMickler Larry J RV6 A · Bell, FLThe pilot's inadequate compensation for gusting crosswinds, which resulted in a bounced landing and nose-over.NTSB ERA17CA012Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Knoxville, TNThe pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA17WA009Accident · 3 fatalForeign investigationCessna 207 · Santa Cruz, Cajamarca, PeruOn October 10, 2016, about 1427 universal coordinated time, a Cessna 207A, Peruvian registration OB-1936-P, was destroyed during a collision with mountainous terrain near Santa Cruz, Cajamarca, Peru. The pilot and two passengers were fatally injured. The…NTSB DCA17WA012Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia (KNKT/NTSC) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on October 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's…NTSB WPR17LA003Accident · Minor injuriesLimited investigationFinal reportMelborn Joe B Kolb Sport 600 · Roberts, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Toone, TNA stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.NTSB DCA17WA006Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB GAA17CA018Accident · Minor injuriesData collectionFinal reportCessna 172 · Argyle, NYThe pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.NTSB GAA17CA012Accident · No injuriesData collectionFinal reportCessna 172 · Ocean Springs, MSThe pilot's failure to maintain airplane control while landing in windy conditions.NTSB CEN17LA014Accident · No injuriesLimited investigationFinal reportCessna 150M · Beasley, TXThe No. 2 cylinder exhaust valve being stuck in the “full open” position due to carbon deposits, which resulted in a total loss of engine power.NTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB GAA17CA013Accident · No injuriesData collectionFinal reportCessna A185 · San Antonio, TXThe pilot's failure to recognize the tailwind condition and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA17CA008Accident · Serious injuriesData collectionFinal reportAlgimantas Jonusas RV-10 · Ashwood, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning and continued flight into instrument meteorological conditions, which resulted in impact with trees and terrain.NTSB DCA17WA032Accident · No injuriesForeign investigationCessna 172 · Brits, North West Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving ZS-MPF, a Cessna 172M airplane that occurred on October 07, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB CEN17LA015Accident · No injuriesLimited investigationFinal reportMilholland Kelly D · Livingston, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.NTSB GAA17CA017Accident · No injuriesData collectionFinal reportPiper PA 17 · Keene Valley, NYThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane and an impact with trees.NTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA17CA014Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe flight instructor’s delayed remedial action, which resulted in his failure to maintain directional control during a go-around and a runway excursion.NTSB GAA17CA010Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Boca Reservoir, CAThe pilot's decision to continue the taxi on unsuitable muddy terrain, which resulted in a nose-over.NTSB ERA17LA007Accident · Serious injuriesLimited investigationFinal reportJames Bruton Flying Flea · Plymouth, CTA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA006Accident · No injuriesLimited investigationFinal reportPiper PA24 · Hollywood, ALA failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power.NTSB ENG17WA002Incident · No injuriesForeign investigationMD Helicopter 500 · Wanaka, New ZealandThe Civil Aviation Authority of New Zealand has notified the NTSB of an incident involving a MD Helicopters MD520N, which occurred on October 6, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…NTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.NTSB ANC17WA002Accident · 1 fatalForeign investigationSteen Skybolt · Blackfalds, CanadaOn October 06, 2016, about 2050 Coordinated Universal Time, an amateur-built Steen Skybolt airplane, C-GWBD, impacted terrain near Blackfalds, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.NTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.NTSB GAA17CA023Accident · No injuriesData collectionFinal reportNorth American Navion · Palmer, AKThe pilot's failure to extend the landing gear for landing.NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.NTSB DCA17CA005Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Denver, COthe flight attendant losing her balance as she was removing her carry-on baggage resulted in her falling against an arm rest causing the serious injury.NTSB WPR17LA005Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Waimea, HIImpact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.NTSB GAA17CA052Accident · No injuriesData collectionFinal reportChaudoin George S RV 10 · Portsmouth, NHThe pilot’s failure to go around after recognizing that the airplane was high and fast, which resulted in a long landing on a wet runway and a runway excursion.NTSB GAA17CA007Accident · No injuriesData collectionFinal reportCessna T182 · Galesburg, ILThe pilot's improper landing flare, which resulted in a bounced, hard landing.NTSB ENG17WA001Accident · No injuriesForeign investigationBoeing 737 · Aldergrove, United KingdomOn October 4, 2016, a Boeing 737-400 experienced a partial right main gear failure during the landing roll at Belfast International Airport (EGAA), Aldergrove, Northern Ireland, United Kingdom. The flight originated from East Midlands Airport (EGNX),…NTSB CEN17LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmot, WIA failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.