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 DFW07CA035Accident · No injuriesData collectionFinal reportPiper J3C-65 · Humnoke, ARThe loss of engine power during initial takeoff climb for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DCA07WA014Incident · No injuriesForeign investigationRaytheon Corporate Jets Premier · Deauville, FranceNTSB CHI07CA033Accident · No injuriesData collectionFinal reportCessna C-425 · Menominee, MIThe pilot failed to maintain control of the aircraft while parking the aircraft, and failed to maintain clearance from the building as the airplane taxied forward. A factor was the terminal.NTSB MIA07CA025Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Miami, FLThe failure of the pilot to maintain directional control during the landing roll resulting in a ground loop, and subsequent wing contact with the runway.NTSB ATL07LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Conyers, GALoss of engine oil for undetermined reasons resulting in oil starvation, failure of the No. 1 connecting rod resulting in the total loss of engine power.NTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.NTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.NTSB DFW07CA034Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Jacksboro, TXThe pilot's improper fuel calculations, which resulted in a loss of engine power due to fuel exhaustion. A factor was the unsuitable terrain encountered during the emergency landing.NTSB DEN07WA031Accident · 1 fatalForeign investigation107.5 Flying One Design DR 107 · Langenthal, SwitzerlandNTSB CHI07LA035Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Atlanta, GAThe exceedance of airplane design stress limits when the pilot did not maintain aircraft control after his attention was diverted to the right side attitude indicator during cruise flight. An additional cause was the aural detection for the autopilot…NTSB NYC07FA038Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601P · West Dover, VTA loss of control during approach for undetermined reasons, which resulted in a collision with trees.NTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.NTSB DFW07CA033Accident · No injuriesData collectionFinal reportStits Flut-R-Bug SA6B · Camerson, TXThe pilot's improper landing flare and inadequate recovery from a bounced landing which resulted in a hard landing. A factor was the delayed remedial action by the flight instructor.NTSB CHI07FA032Accident · 2 fatalField investigationFinal reportCessna 172 · Crookston, MNThe pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.NTSB SEA07CA032Accident · No injuriesData collectionFinal reportRiley D-16A · Point Roberts, WAthe pre-existing crack in the nose wheel fork, which allowed separation of the nose wheel during the takeoff roll, resulting in collapse of the nose landing gear.NTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.NTSB LAX07WA057Accident · 1 fatalForeign investigationRobinson R44 · Nadi, FijiNTSB LAX07TA051Accident · No injuriesFinal reportLearjet 36 · San Diego, CAThe pilot's failure to maintain aircraft control while maneuvering, which resulted in exceeding the design stress limits of the aircraft. Contributing to the accident was the sunglare.NTSB DEN07LA030Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Steamboat Springs, COThe inadequate design of the engine mount, which caused an uncommanded left turn, loss of directional control, and impact with snow-covered terrain. Contributing to the accident was the low nose gear tire pressure.NTSB DEN07WA034Accident · 1 fatalForeign investigationGrob G 180 · Mindelheim, GermanyNTSB NYC07WA044Accident · 2 fatalForeign investigationBell 412 · Cafasse, Torino, ItalyNTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.NTSB LAX07CA050Accident · No injuriesData collectionFinal reportRobinson R22B · Redding, CAThe student's misjudged landing flare, the instructor's inadequate supervision of the flight, and the instructor's failure to maintain adequate rotor rpm.NTSB NYC07WA039Accident · 1 fatalForeign investigationRobinson R-44 · Venice, ItalyNTSB NYC07CA050Accident · No injuriesData collectionFinal reportCessna 152 · Block Island, RIThe pilot's failure to maintain adequate clearance while taxiing, which resulted in a collision with a construction vehicle. A factor in this accident was the location of the construction vehicle, which was parked on the ramp, adjacent to the parking area.NTSB LAX07LA048Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Las Vegas, NVA loss of power in the right engine due to fuel starvation. The fuel starvation was the result of the pilot's improper fuel selector position setting.NTSB DFW07LA027Accident · No injuriesLimited investigationFinal reportBell BH 206L-3 · Brownwood, TXThe fracture of the turbine-to-compressor coupling and subsequent overspeed failure of the first stage turbine wheel as result of the improper re-assembly of the engine by maintenance personnel. A contributing factor was the lack of suitable terrain for the…NTSB DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.NTSB CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.NTSB CHI07CA027Accident · Serious injuriesData collectionFinal reportCessna 172S · Warroad, MNThe propeller striking the individual who was positioning the propeller in anticipation of hand-propping the engine.NTSB SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.NTSB SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.NTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.NTSB ATL07CA022Accident · No injuriesData collectionFinal reportCessna 172N · Reidsville, NCThe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an on ground collision with trees.NTSB NYC07WA062Accident · Serious injuriesForeign investigationPiper PA-46-500TP · Tartu, EstoniaNTSB LAX07CA046Accident · No injuriesData collectionFinal reportCessna T210M · Las Vegas, NVfuel exhaustion due to the pilot's inadequate fuel consumption calculations and his failure to refuel the airplane during the cross-country flight,.NTSB CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.NTSB ATL07LA021Accident · Serious injuriesLimited investigationFinal reportTennyson Howard Baslee DR-1 · Macon, GAThe pilot/owner's improper design change which resulted in a blocked carburetor inlet and a loss of engine power.NTSB MIA07WA022Accident · 6 fatalForeign investigationBeech B55 · Coyhaique, ChileNTSB LAX07LA045Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Queen Creek, AZThe total loss of engine power resulting from the failure of the engine's air compressor due to a seized piston, which resulted in the stoppage of the oil pump, fuel pump, and tachometer generator, in addition to the compressor. The underlying reason for the…NTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB DFW07LA026Accident · 2 fatalLimited investigationFinal reportKeesler Pulsar · Alvarado, TXThe pilot's improper handling of the airplane while manuevering at a low altitude, which resulted in an inadvertant stall.NTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.NTSB CHI07CA031Accident · No injuriesData collectionFinal reportCessna 120 · Perryville, MOThe pilot's failure to maintain directional control during landing which resulted in an overload of the tailwheel attachment structure in the fuselage.NTSB SEA07LA022Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Lyons, ORA severing of the helicopter's cyclic and collective rods by one of the load lifting slings following the failure of the other sling. A contributing factor was the hard landing due to the fact that an autorotation was not possible.NTSB DFW07LA029Accident · No injuriesLimited investigationFinal reportBeech V35 · Mountain View, ARThe loss of engine power due to oil starvation as a result of a broken oil pressure line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA031Accident · No injuriesData collectionFinal reportCessna 210 · Baytown, TXThe failure of the main landing gear to fully extend for an undetermined reason during takeoff-initial climb, which resulted in a gear-up landing.NTSB DFW07CA028Accident · No injuriesData collectionFinal reportCessna 172N · Spring, TXLoss of directional control for undetermined reasons.NTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.