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.

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.Dec 13, 1999 · N58408 · Substantial damageNTSB 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.Dec 13, 1999 · N41910 · Substantial damageNTSB 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.Dec 13, 1999 · N3807Y · DestroyedNTSB 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.Dec 12, 1999 · N270BB · DestroyedNTSB NYC00MA048Accident · 3 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Gouldsboro, PAThe improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.Dec 12, 1999 · N50PL · DestroyedNTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.Dec 12, 1999 · N260XX · Substantial damageNTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.Dec 12, 1999 · N5279Z · Substantial damageNTSB IAD00WA012Accident · Minor injuriesForeign investigationde Havilland DH-6 Twin Otter · Ago-6, AYDec 12, 1999 · CGKBG · DestroyedNTSB IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.Dec 12, 1999 · N78ME · Substantial damageNTSB 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.Dec 12, 1999 · N717SK · Substantial damageNTSB 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.Dec 12, 1999 · N739ST · Substantial damageNTSB CHI00LA043Accident · 2 fatalLimited investigationFinal reportMcCarty Wittman W-8 Tailwind · Jamestown, NDthe wing spar failure due to its inadequate construction by the owner/builder.Dec 12, 1999 · N654 · DestroyedNTSB 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.Dec 11, 1999 · N5347C · Substantial damageNTSB NYC00LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Reading, PAThe failure of the number two connecting rod after an improper overhaul by maintenance personnel.Dec 11, 1999 · N6715U · Substantial damageNTSB MIA00FA048Accident · 1 fatalField investigationFinal reportCessna U-3A · Brooksville, MSThe in-flight loss of control for undetermined reasons resulting in the collision with terrain.Dec 11, 1999 · N8063X · DestroyedNTSB 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…Dec 11, 1999 · N27181 · Substantial damageNTSB FTW00RA043Accident · 1 fatalForeign investigationBell UH-1H · Cali, ColombiaDec 11, 1999 · PN169NTSB 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.Dec 11, 1999 · N3912C · Substantial damageNTSB 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.Dec 11, 1999 · N53910 · Substantial damageNTSB 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…Dec 10, 1999 · N5038Q · DestroyedNTSB 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.Dec 9, 1999 · N581BC · DestroyedNTSB MIA00WA045Accident · 1 fatalForeign investigationBeech B95A · Maizal, Dominican RepublicDec 9, 1999 · N1291Z · DestroyedNTSB 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.Dec 9, 1999 · N9234H · Substantial damageNTSB 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.Dec 9, 1999 · N2179S · DestroyedNTSB 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.Dec 9, 1999 · N69LM · Substantial damageNTSB 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.Dec 9, 1999 · N525KL · DestroyedNTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.Dec 8, 1999 · N7565G · Substantial damageNTSB 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.Dec 8, 1999 · N5864L · Substantial damageNTSB 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.Dec 8, 1999 · N39696 · DestroyedNTSB 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.Dec 7, 1999 · N1747U · DestroyedNTSB 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.Dec 6, 1999 · N192DC · DestroyedNTSB IAD00WA011Accident · 10 fatalForeign investigationPiper PA31-350 · Rand, South AfricaDec 6, 1999 · ZS-OJY · DestroyedNTSB 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.Dec 6, 1999 · N111DN · Minor damageNTSB ANC00LA017Accident · No injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.Dec 6, 1999 · N5187B · Substantial damageNTSB NYC00LA045Accident · Minor injuriesLimited investigationFinal reportCessna TR 182 · Clarksville, MDDeer that entered the runway environment while the pilot was executing a takeoff.Dec 5, 1999 · N5260S · Substantial damageNTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.Dec 5, 1999 · N49328 · Substantial damageNTSB IAD00WA010Accident · 2 fatalForeign investigationCessna 206 · Port-Au-Prince, HaitiDec 5, 1999 · HK283 · DestroyedNTSB FTW00LA040Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Ship Shoal 225The loss of power for undetermined reasons. A factor was the rough water condition.Dec 5, 1999 · N600CK · Substantial damageNTSB 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.Dec 5, 1999 · N3719T · Substantial damageNTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.Dec 4, 1999 · N1936V · Substantial damageNTSB 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.Dec 4, 1999 · N1773X · Substantial damageNTSB 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.Dec 4, 1999 · N3848K · Substantial damageNTSB 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.Dec 4, 1999 · N177J · Substantial damageNTSB 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.Dec 4, 1999 · N3QV · Substantial damageNTSB 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.Dec 3, 1999 · N11KV · Substantial damageNTSB 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…Dec 3, 1999 · N9235N · Substantial damageNTSB 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…Dec 3, 1999 · N3038N · 2 aircraft · DestroyedNTSB 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.Dec 3, 1999 · N7183Y · Substantial damageNTSB IAD00RA009Accident · 10 fatalForeign investigationBell 212 · Rangali, MaldivesDec 3, 1999NTSB 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.Dec 3, 1999 · N5245G · Substantial damage