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 DFW06CA116Accident · Minor injuriesData collectionFinal reportHeliotech H-250 · Woodville, TXThe pilot's failure to maintain clearance with obstructions at the departure end of the airstrip during an aborted landing. A contributing factor was dusk light conditions.NTSB SEA06CA098Accident · No injuriesData collectionFinal reportCessna 172N · Billings, MTThe pilot's failure to maintain clearance from a sign while taxiing to parking.NTSB LAX06LA153Accident · 1 fatalLimited investigationFinal reportRonald R Russell RV-6 · Death Valley, CAa fuel starvation induced loss of engine power due to a likely vapor lock condition in the fuel lines.NTSB LAX06CA152Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Phoenix, AZthe failure of both pilots to maintain Vmc and directional control during a go-around. Also causal was an inoperative engine caused by flight instructor's failure to ensure that the fuel system was correctly configured for two engine operation by moving the…NTSB LAX06LA151Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. A factor was the loss of thermal lift.NTSB LAX06CA160Accident · No injuriesData collectionFinal reportBeech C24R · Sacramento, CAthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in a gear up landing. A contributing factor was the pilot's diverted attention during the approach.NTSB ATL06WA074Accident · 1 fatalForeign investigationPiper PA-34-220T · San Javier, SpainNTSB WAS06WA009Accident · 3 fatalForeign investigationCessna 208B · Kasese, UgandaNTSB MIA06CA100Accident · No injuriesData collectionFinal reportCessna 170B · Fort Pierce, FLThe failure of the pilot-in-command to maintain directional control during the landing roll.NTSB MIA06CA099Accident · No injuriesData collectionFinal reportHoward DGA-15P · Merritt Island, FLThe failure of the pilot to comply with the before landing checklist for his failure to lock the tailwheel.NTSB LAX06CA173Accident · No injuriesData collectionFinal reportCirrus SR-20 · Willows, CAthe pilot's misjudged landing flare and improper recovery from a bounced landing.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB LAX06CA149Accident · Minor injuriesData collectionFinal reportM.C. Thomas Thorpe T-18 · Reno, NVthe pilot's failure to maintain directional control. A contributing factor was the certified flight instructor's inadequate supervision of the flight.NTSB DFW06CA113Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · De Witt, ARThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the gusty winds.NTSB CHI06CA122Accident · No injuriesData collectionFinal reportCessna 182T · Madison, WIThe student pilot's failure to maintain directional control during landing which resulted in a runway excursion and collapse of the nose landing gear. A contributing factor was the pilot's inadequate compensation for the crosswind condition. Additional…NTSB ATL06LA072Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Monroeville, ALPartial loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over.NTSB SEA06CA088Accident · Minor injuriesData collectionFinal reportPotts MA-5 · Kalispell, MTSeparation of the left main landing gear during the landing roll for an undetermined reason, which resulted in the airplane nosing down.NTSB ENG06RA037Accident · No injuriesForeign investigationBell 206B3 · San Paulo, BrazilNTSB ATL06IA071Incident · No injuriesIncident investigationFinal reportBeech C90A · Raleigh, NCThe inadequate manufacturing process, which resulted in a windshield fire and subsequent emergency landing.NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB SEA06CA086Accident · No injuriesData collectionFinal reportSchmidt RV7A · Northport, WAThe pilot's failure to maintain directional control during the landing flare/touchdown. Factors contributing to the accident included the gusty wind and soft terrain conditions which resulted in the aircraft nosing over during the landing roll.NTSB MIA06FA098Accident · 2 fatalField investigationFinal reportBeech A24R · Okeechobee, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation and an in-flight break up. Contributing to the accident were the dark night and thunderstorms.NTSB ANC06LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tuluksak, AKThe pilot's inadvertent stall/mush during takeoff-initial climb, which resulted in an in-flight collision with trees and terrain. Factors associated with the accident were the pilot's excessive loading of the airplane, his inadequate preflight planning, and a…NTSB SEA06WA085Accident · No injuriesForeign investigationGarlick UH-1H · Sarawak, MalaysiaNTSB NYC06FA104Accident · 1 fatalField investigationFinal reportCessna 172L · Montgomery Twp, PAAn impact with mountainous terrain for an undetermined reason.NTSB MIA06CA097Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Lake Wales, FLThe pilot's failure to abort the takeoff resulting in an overrun of the runway and encounter with terrain.NTSB DFW06LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 777-233ER · DFW Int'l Apt, TXThe in-flight encounter with turbulence in clouds resulting in a flight attendant being injured.NTSB CHI06MA121Accident · No injuriesMajor investigationFinal reportGeneral Atomics Predator B · Nogales, AZThe pilot's failure to use checklist procedures when switching operational control from PPO-1 to PPO-2, which resulted in the fuel valve inadvertently being shut off and the subsequent total loss of engine power, and lack of a flight instructor in the GCS, as…NTSB CHI06CA130Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Brook, INThe pilot's intentional decision to leave the helicopter unattended with the engines running which resulted in a dynamic rollover. The inadvertent dynamic rollover was a factor.NTSB SEA06CA084Accident · No injuriesData collectionFinal reportBeech P-35 · Bandon, ORThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.NTSB NYC06LA101Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Norwood, MAImproper maintenance, which resulted in a fatigue fracture of the dual magneto mounting flange, and a subsequent loss of engine power.NTSB CHI06LA119Accident · 1 fatalLimited investigationFinal reportWoods Skyboy Quick Kit · Huntington, INThe flight's impact with terrain while maneuvering due to undetermined reasons.NTSB ATL06LA070Accident · 1 fatalLimited investigationFinal reportLancair Lancair 360 · Charleston, SCThe pilot's failure to maintain sufficient airspeed during a climb to preclude a stall, which resulted in a loss of control and an in-flight collision with terrain. A factor associated with the accident was an inadvertent stall.NTSB ATL06LA069Accident · 1 fatalLimited investigationFinal reportCessna 182B · Gainesville, GAThe pilots improper preflight planning and preparation which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA06CA081Accident · No injuriesData collectionFinal reportCessna 172 S · Malad City, IDThe private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.NTSB NYC06CA103Accident · No injuriesData collectionFinal reportMaule M-5-210C · Linville, VAThe pilot's improper decision to depart with a tailwind.NTSB NYC06CA102Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Jeannette, PAExcessively worn brake pads and rotors, which resulted in a runway overrun and subsequent collision with a tree.NTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.NTSB LAX06FA148Accident · 2 fatalField investigationFinal reportCessna T337C · Wrightwood, CAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions, which resulted in controlled flight into mountainous terrain.NTSB LAX06CA146Accident · Minor injuriesData collectionFinal reportGrumman American AA-1C · San Diego, CAThe pilot's failure to maintain adequate airspeed, which resulted in a stall during initial climb. A contributing factor was his diverted attention.NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…NTSB DEN06IA068Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Denver, COThe ground crew's failure to retract the adjacent jetway and to verify the airplane's clearance with the jetway as it taxied.NTSB ANC06FA048Accident · 5 fatalField investigationFinal reportCessna 170B · Chugiak, AKThe inadequate visual lookout by the pilots of both airplanes during cruise flight, which resulted in their failure to see-and-avoid each other, and a subsequent midair collision.NTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB DFW06FA110Accident · 1 fatalField investigationFinal reportMooney M20K · Columbus, MSThe loss of engine power for undetermined reasons. A contributing factor was the pilot's improper decision to forgo suitable forced landing opportunities in an attempt to return to the airport.NTSB DFW06CA111Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Midlothian, TXThe inadvertent deployment of the spoilers during the aero tow takeoff for undetermined reasons, resulting in a hard landing.NTSB DEN06LA070Accident · No injuriesLimited investigationFinal reportCessna T-R182RG · Englewood, COthe pilot inadvertently retracting the landing gear.NTSB DEN06CA069Accident · Serious injuriesData collectionFinal reportAerostar International RX 8 · Albuquerque, NMthe pilot's inability to maintain a proper descent rate due to the high winds, resulting in a hard landing. A contributing factor was the high wind conditions.NTSB CHI06CA123Accident · No injuriesData collectionFinal reportCessna 172E · Richmond, INThe pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.