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 DEN00LA038Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Rock Springs, WYA forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…Jan 8, 2000 · N128Y · Substantial damageNTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.Jan 8, 2000 · N2336Z · DestroyedNTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…Jan 7, 2000 · N3721J · Substantial damageNTSB NYC00FA063Accident · 2 fatalField investigationFinal reportCessna 310N · Old Forge, PABoth pilots' failure to adequately manage the fuel supply, which resulted in fuel starvation.Jan 6, 2000 · N70CM · Substantial damageNTSB MIA00FA064Accident · 1 fatalField investigationFinal reportCessna 172R · Atlantic Ocean (Atlantic Ocean)The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…Jan 6, 2000 · N156RA · DestroyedNTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.Jan 6, 2000 · N5918S · DestroyedNTSB IAD00LA015Accident · No injuriesLimited investigationFinal reportBell 206A · Brutus, NYWas the pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness.Jan 5, 2000 · N206GR · Substantial damageNTSB DEN00LA036Accident · No injuriesLimited investigationFinal reportBeech B200 · Jackson, WYThe pilot misreading the visual approach lighting system, resulting in his failure to maintain proper alignment with the runway and his selection of an improper touchdown point. Factors were the low ceiling weather conditions and the snow covered runway.Jan 5, 2000 · N895TT · Substantial damageNTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.Jan 4, 2000 · N229FF · Substantial damageNTSB LAX00LA071Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Chandler, AZthe fatigue fracture and separation of the secondary drive shaft, which resulted from the manufacturer's inadequate quality control process.Jan 4, 2000 · N89678 · Substantial damageNTSB ATL00FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Cordesville, SCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.Jan 4, 2000 · N5703P · Substantial damageNTSB MIA00FA060Accident · No injuriesField investigationFinal reportRobinson R44 · Cayey, PRThe pilot's failure to use carburetor heat as required by the Pilot's Operating Handbook resulting in a loss of engine and rotor rpm, forced landing to none suitable terrain (residence), and subsequent roll over.Jan 3, 2000 · N233MP · Substantial damageNTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.Jan 3, 2000 · N3690L · Substantial damageNTSB FTW00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Corning, ARThe loss of engine power for an undetermined reason. A factor was the dark night light condition.Jan 3, 2000 · N87NF · Substantial damageNTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.Jan 3, 2000 · N999SW · Substantial damageNTSB LAX00LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Dos Palos, CAA partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.Jan 2, 2000 · N7249T · Substantial damageNTSB FTW00LA057Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Odessa, TXThe separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jan 2, 2000 · N4389W · Substantial damageNTSB DEN00FA037Accident · 1 fatalField investigationFinal reportCessna 421B · Telluride, COThe non-instrument rated pilot's intentional flight into IMC, and his subsequent spatial disorientation that resulted in an inadvertent stall. A factor was the snow showers weather condition.Jan 2, 2000 · N421CF · DestroyedNTSB DCA00WA018Incident · No injuriesForeign investigationBoeing 737-3K2 · Amsterdam, NetherlandsJan 2, 2000 · PHHVV · Minor damageNTSB MIA00LA063Accident · No injuriesLimited investigationFinal reportCessna 550 · Homestead, FLAn inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.Jan 1, 2000 · N752CC · Substantial damageNTSB ATL00FA019Accident · 2 fatalField investigationFinal reportBellanca BL-17-30A · Monteagle, TNThe pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.Jan 1, 2000 · N8821V · DestroyedNTSB MIA00WA062Accident · No injuriesForeign investigationBeech 99A · St. Barthelemy, WNDec 31, 1999 · N491BB · Substantial damageNTSB LAX00LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fallbrook, CAthe pilot's misjudged altitude and distance during a night landing approach, which resulted in an undershoot.Dec 31, 1999 · N1412T · Substantial damageNTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.Dec 31, 1999 · N9225D · Substantial damageNTSB CHI00LA054Accident · Minor injuriesLimited investigationFinal reportAerostar S49A · Flandreau, SDThe pilot's inadequate compensation for wind conditions, and the burner becoming disconnected from the balloon's frame. A contributing factor was the high wind condition.Dec 31, 1999 · N6316U · DestroyedNTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…Dec 30, 1999 · N374TC · Substantial damageNTSB LAX00LA066Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot's decision to takeoff downwind and the subsequent failure to achieve translational lift before contact with the water.Dec 30, 1999 · N9162F · Substantial damageNTSB DEN00LA034Accident · Minor injuriesLimited investigationFinal reportPrice Glasair 1-RG · Ruidoso, NMThe failure of the pilot to perform an adequate preflight, and the subsequent partial power loss as a result of water contamination in the fuel. A factor was the lack of suitable terrain for a forced landing.Dec 30, 1999 · N1190D · Substantial damageNTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.Dec 29, 1999 · N2116W · Substantial damageNTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…Dec 29, 1999 · N3276A · Substantial damageNTSB LAX00FA061Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Avalon, CAA loose pneumatic fitting caused the engine to go to flight idle power at a low altitude, which resulted in a forced landing in hilly terrain.Dec 28, 1999 · N3593S · DestroyedNTSB FTW00LA055Accident · No injuriesLimited investigationFinal reportCessna 172L · New Orleans, LAThe pilot's inadvertent starting of the engine. Factors were the pilot's failure to set the mixture control to the off position, and the intermittent short in the starter switch.Dec 28, 1999 · N172GT · Substantial damageNTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.Dec 28, 1999 · N6144R · DestroyedNTSB SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.Dec 27, 1999 · N5933P · Substantial damageNTSB FTW00LA054Accident · No injuriesLimited investigationFinal reportCessna 150H · Sinton, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Dec 27, 1999 · N7290S · Substantial damageNTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.Dec 27, 1999 · N5697N · DestroyedNTSB LAX00LA064Accident · No injuriesLimited investigationFinal reportBeech 65-80 · Mesa, AZThe collapse of a main landing gear due to damage from a hard landing at an undetermined time.Dec 26, 1999 · N184R · Substantial damageNTSB LAX00LA059Accident · Minor injuriesLimited investigationFinal reportQuest II Walsh Aventura II · Antioch, CAThe pilot's inattention to the fact that he had failed to retract the landing gear wheels prior to performing a water landing.Dec 26, 1999 · N8180Q · Substantial damageNTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.Dec 26, 1999 · N8523X · Substantial damageNTSB LAX00LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gualala, CAThe student pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall/mush and a collision with the ground.Dec 26, 1999 · N45886 · Substantial damageNTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.Dec 26, 1999 · N8395V · Substantial damageNTSB IAD00LA014Accident · Minor injuriesLimited investigationFinal reportPrudhomme Velocity RG 173 · Richmond, VAthe improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.Dec 26, 1999 · N242JP · Substantial damageNTSB CHI00FA050Accident · No injuriesField investigationFinal reportIsrael Aircraft Industries 1124A · Milwaukee, WIThe failure of the first stage pressure reducer in the oxygen regulator assembly.Dec 26, 1999 · N422BC · Substantial damageNTSB NYC00LA061Accident · Minor injuriesLimited investigationFinal reportZielke RV-4 · Florence, NJFailure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.Dec 25, 1999 · N8ZZ · Substantial damageNTSB DEN00LA031Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · San Luis, COThe pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.Dec 25, 1999 · N1941B · Substantial damageNTSB CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,Dec 25, 1999 · N7493E · Substantial damageNTSB CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.Dec 25, 1999 · N1363K · Substantial damageNTSB DEN00IA032Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · Salt Lake City, UTImproper assembly of the wheel during build up in the operator's maintenance facilities.Dec 24, 1999 · N305WA · Minor damageNTSB CHI00LA055Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Mokane, MOfuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.Dec 24, 1999 · N2012D · Substantial damageNTSB ANC00LA021Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Bethel, AKThe pilot's failure to remove frost from the airplane prior to flight, and an inadvertent stall/mush.Dec 24, 1999 · N1864 · Substantial damage