NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 CHI00LA044Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Salina, KSThe pilot's failure to follow the published practice autorotation procedures, the improper use of throttle, and the inadequate flare.NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB CHI00FA042Accident · 2 fatalField investigationFinal reportCessna 210D · Saint Charles, MOthe aircraft control not maintained by the pilot and the pilot exceeded the design limits of the aircraft. The clouds and night conditions were contributing factors.NTSB SEA00FA031Accident · 1 fatalField investigationFinal reportMooney M20-M · Missoula, MTEngine failure for undetermined reasons. Factors include the lack of suitable terrain for an emergency landing, trees and mountainous terrain.NTSB NYC00MA048Accident · 3 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Gouldsboro, PAThe improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.NTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.NTSB IAD00WA012Accident · Minor injuriesForeign investigationde Havilland DH-6 Twin Otter · Ago-6, AYNTSB IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.NTSB FTW00LA042Accident · No injuriesLimited investigationFinal reportKing Lancair 235/320 · Sterling City, TXThe fatigue fracture of the propeller attaching bolts, due to improper torque during the installation of the propeller by other maintenance personnel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Springhill, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of aircraft control. Factors were the gusty winds, and the pilot's inadequate weather evaluation.NTSB CHI00LA043Accident · 2 fatalLimited investigationFinal reportMcCarty Wittman W-8 Tailwind · Jamestown, NDthe wing spar failure due to its inadequate construction by the owner/builder.NTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.NTSB NYC00LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Reading, PAThe failure of the number two connecting rod after an improper overhaul by maintenance personnel.NTSB MIA00FA048Accident · 1 fatalField investigationFinal reportCessna U-3A · Brooksville, MSThe in-flight loss of control for undetermined reasons resulting in the collision with terrain.NTSB LAX00LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Scottsdale, AZThe pilot's failure to follow the manufacturer's published emergency procedures for engine loss of power resulting in a forced landing in an open construction area where the airplane collided with a berm. A related factor was the loss of engine power in the…NTSB FTW00RA043Accident · 1 fatalForeign investigationBell UH-1H · Cali, ColombiaNTSB DEN00LA026Accident · No injuriesLimited investigationFinal reportCessna 421C · Gillette, WYThe collision with a deer on the runway during a night landing. A factor was the dark night.NTSB ANC00LA019Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wasilla, AKThe pilot's failure to remove frost from the wing surface of the airplane. A factor in the accident was the pilot's delay in aborting the takeoff run.NTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…NTSB NYC00FA047Accident · 4 fatalField investigationFinal reportBeech 58TC · Hasbrouck Hts., NJthe failure of the pilot to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin.NTSB MIA00WA045Accident · 1 fatalForeign investigationBeech B95A · Maizal, Dominican RepublicNTSB MIA00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pikeville, NCThe inadequate supervision of the private-rated pilot by the certified flight instructor for allowing the airplane to impact terrain during a simulated forced landing procedure to an open field.NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.NTSB CHI00LA036Accident · No injuriesLimited investigationFinal reportCessna 172M · Ava, MOthe improper in-flight decision made by the pilot. Factors to the accident were the charts/other manuals depicting the incorrect frequency, the dirt bank, and the rocks.NTSB CHI00FA040Accident · 6 fatalField investigationFinal reportCessna 525 · Branson, MOthe pilot descended below the minimum altitude for the segment of the GPS approach. Factors relating to the accident were low ceilings, rain, and pilot fatigue.NTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.NTSB MIA00LA044Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5 · St. Elmo, ALThe failure of the pilot to maintain airspeed resulting in the in-flight loss of control while maneuvering for a forced landing in a field after the loss of engine power. Contributing factors were the loss of engine power due to water-contaminated fuel.NTSB MIA00FA043Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pelham, ALThe student pilot's decision to continue the visual flight rules flight into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.NTSB ANC00FA018Accident · 6 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.NTSB LAX00LA049Accident · 1 fatalLimited investigationFinal reportCorbin/King Osprey 2 · Chula Vista, CAThe pilot exceeded the design stress limits of the airplane resulting in wing overload and separation.NTSB IAD00WA011Accident · 10 fatalForeign investigationPiper PA31-350 · Rand, South AfricaNTSB DEN00IA023Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Salt Lake City, UTTotal failure of the main landing gear retract actuator due to stress corrosion caused by the use of a faulty sealant by company maintenance personnel that allowed moisture to enter the joint. A factor was the use of an improper fillet seal.NTSB ANC00LA017Accident · No injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.NTSB NYC00LA045Accident · Minor injuriesLimited investigationFinal reportCessna TR 182 · Clarksville, MDDeer that entered the runway environment while the pilot was executing a takeoff.NTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.NTSB IAD00WA010Accident · 2 fatalForeign investigationCessna 206 · Port-Au-Prince, HaitiNTSB FTW00LA040Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Ship Shoal 225The loss of power for undetermined reasons. A factor was the rough water condition.NTSB ANC00LA016Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F-19 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area. Factors associated with the accident were snow-covered terrain, and a tree.NTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.NTSB NYC00LA046Accident · No injuriesLimited investigationFinal reportCessna 210L · Columbus, OHThe pilot's failure to verify landing gear extension. Factors were the unreliable retraction/extension assembly, and the flying club's continued operation of the airplane with known deficiencies in the equipment.NTSB MIA00LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pelzer, SCThe student pilot's failure to recognize and compensate for changing wind conditions while on final approach and landing and his failure to initiate a timely go-around, resulting in collision with trees and a utility pole.NTSB MIA00LA039Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Creedmore, NCThe pilot's failure to select the reserve position of the fuel tank resulting in loss of engine power due to fuel starvation and a nose over during a forced landing.NTSB LAX00LA048Accident · Serious injuriesLimited investigationFinal reportOehling Questair Venture · Auburn, CAThe owner/builder's failure to properly bleed the brake system following replacement of the right brake line, which caused the right brake to not function and led to the pilot's inability to maintain directional control.NTSB SEA00LA028Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Salem, ORFailure of the pilot to maintain ground clearance, resulting in the long-line snagging and then striking the tail rotor.NTSB MIA00LA038Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Palm Bch Garden, FLThe sailplane pilot's failure to comply with standard emergency procedures for 'sailplane release failure' upon its occurrence and his maneuvering of the sailplane while still tethered to the tow plane resulting in the inflight loss of control and engine…NTSB MIA00FA041Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Deland, FLThe inadequate visual lookout by the pilot-in-command (PIC)/certified flight instructor (CFI) of both aircraft. Contributing factors in the accident were: 1) the frequency congestion of the CTAF 2) the poor in-flight planning decision by the PIC/CFI of the…NTSB LAX00LA050Accident · No injuriesLimited investigationFinal reportRobinson R22 Mariner II · Minden, NVthe result of a foreign object contacting the tail rotor blade(s) while the aircraft was hover taxiing, which caused blade separation with subsequent loss of anti-torque (lateral) control.NTSB IAD00RA009Accident · 10 fatalForeign investigationBell 212 · Rangali, MaldivesNTSB DEN00LA024Accident · No injuriesLimited investigationFinal reportCessna 305A · Akron, COThe failure of the four bolts which attach the right main landing gear assembly to the landing gear strut.