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 ATL94FA036Accident · Serious injuriesField investigationFinal reportCessna 172H · Perry, GAThe pilot's inadequate aircraft preflight inspection, in that he did not remove the flight control gust lock prior to the flight. A factor was the use of an unapproved, unmarked rivet as a flight control lock.NTSB LAX94LA111Accident · No injuriesLimited investigationFinal reportBritten-Norman BN2A-8 Islander · Santa Rosa Isl, CAA failure of the pilot-in-command to maintain a proper glide path to the runway and his misjudgement of the touchdown point that resulted in an undershoot and subsequent hard landing.NTSB DCA94MA027Accident · 5 fatalClass 1 · MajorFinal reportJetstream 4101 · Columbus, OH(1) An aerodynamic stall that occurred when the flightcrew allowed the airspeed to decay to stall speed following a very poorly planned and executed approach characterized by an absence of procedural discipline; (2) Improper pilot response to the stall…NTSB ANC94LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKLoss of engine power due to improper procedures used by the PIC. A factor contributing to the accident was the snow covered terrain.NTSB FTW94LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Vacherie, LAWas fuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB SEA94LA047Accident · Minor injuriesLimited investigationFinal reportMBB BO-105S · Clearwater, ORThe pilot in command's failure to maintain clearance with the transmission wires. Factors contributing to the accident were the wires and sunglare.NTSB MIA94MA048Accident · 10 fatalMajor investigationFinal reportBeech B90 · Okeechobee, FLThe pilot's improper remedial action concerning a right engine power anomaly, and his failure to maintain adequate airspeed during go-around from an aborted precautionary landing, which resulted in a loss of aircraft control and an uncontrolled descent.…NTSB NYC94LA046Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Richmond Height, OHThe pilot's loss of directional control during landing, resulting in a departure from the runway and the subsequent encounter with soft terrain and collapse of the nose gear. A factor related to the accident was the icy runway conditions.NTSB MIA94LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Live Oak, FLThe improper use of the fuel selector by the pilot-in-command by switching to an empty fuel tank. Contributing to the accident was the pilot's failure to switch back to a tank with fuel.NTSB LAX94LA090Accident · 1 fatalLimited investigationFinal reportBell 206B · Coolidge Dam, AZthe pilot's selection of a cruise altitude insufficient to ensure adequate obstacle clearance and his inadequate visual lookout. A factor in the accident was the inconspicuousness of the power lines.NTSB NYC94LA045Accident · No injuriesLimited investigationFinal reportCessna 206A · Williamsburg, VAan exhaust valve failure that created a hole in the piston, which allowed the complete loss of engine oil, resulting in the subsequent forced landing.NTSB LAX94LA092Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Avalon, CAThe pilot's failure to see and avoid the powerlines. A related factor was the pilot's poor judgment in flying at low altitude.NTSB SEA94LA046Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Manila, UTThe pilot's failure to maintain clearance. Factors include a tailwind, gusts, and a tree just off the departure end of the field used for takeoff.NTSB MIA94LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Raymond, MSThe pilot-in-command's delay in identifying carburetor ice and improper use of carburetor heat.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.NTSB FTW94FA060Accident · 5 fatalField investigationFinal reportPalmer Hawk BM-4 · Pearland, TXInadequate visual lookout by the pilot of the hawk BM-4, which resulted in his failure to see-and-avoid the Cessna 172. The BM-4 pilot's non-standard procedure for entering the traffic pattern was a related factor.NTSB SEA94FA045Accident · 2 fatalField investigationFinal reportCessna 172D · Bandon, ORThe pilot's failure to maintain adequate clearance. Factors include strong, gust winds, a dark night, and the pilot's lack of experience in nighttime operations.NTSB MIA94IA043Incident · No injuriesIncident investigationFinal reportBoeing 767-322 · Miami, FLEmergency procedure initiated by an unqualified person.NTSB MIA94FA044Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Destin, FLAirspeed not maintained, inadvertent stall/mush, and altitude inadequate for recovery from the inflight loss of control by the pilot-in-command while circling for landing.NTSB FTW94LA061Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mason, TXLoss of aircraft control for an undetermined reason.NTSB FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.NTSB FTW94FA059Accident · Serious injuriesField investigationFinal reportCessna 177RG · La Veta, COThe pilot's improper inflight decision to enter a mountain pass at an inadequate altitude, causing the aircraft's climb performance to be exceeded. Factors were turbulence and downdrafts.NTSB SEA94LA044Accident · No injuriesLimited investigationFinal reportSommerauer Glasair I RG · Ogden, UTA loose fuel line fitting, and fuel starvation. Factors include an intentional wheels up forced landing, and soft rough/uneven terrain.NTSB SEA94LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Cheyenne, WYThe pilot's poor in flight decision. Factors include high winds, gusts, and the pilot's lack of total experience operating in high wind conditions.NTSB MIA94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vicksburg, MSThe pilot did not maintain the proper glidepath. Failure of the electrical system and inadequate maintenance by company maintenance personnel were factors in the accident.NTSB MIA94LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lantana, FLThe pilot-in-command's failure to obtain emergency assistance after becoming temporarily lost, resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the dispatch of the student on the cross-country flight by the CFI…NTSB LAX94LA088Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B-TR2 · Riverside, CAThe pilot's improper recovery from a bounced landing. A factor related to the accident was: the pilot's improper flare for landing.NTSB LAX94FA089Accident · 1 fatalField investigationFinal reportGrumman AA-1C · Santa Paula, CAA failure of the pilot to maintain adequate airspeed, and subsequent inadvertent stall during an undetermined loss of engine power following takeoff.NTSB LAX94LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · El Monte, CAThe pilot's delayed decision to abort the takeoff and improper use of the airplane's throttle.NTSB FTW94FA057Accident · 3 fatalField investigationFinal reportCessna 177RG · Van Horn, TXThe pilot exceeded the design stress limits of the aircraft after a loss of control which resulted from VFR flight into instrument meteorological conditions. Factors were the weather, the pilot's lack of instrument training and experience, and his failure to…NTSB ATL94LA035Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mobile, ALAn inadequate major repair by company maintenance personnel who failed to install the cotter pin which secured the retaining nut of the right main rotor hub teeter pin.NTSB LAX94LA084Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74L · Los Banos, CAA failure of the pilot to utilize carburetor heat. The carburetor icing conditions were a factor in the accident.NTSB LAX94LA083Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Scottsdale, AZA failure of the pilot-in-command to adequately conduct a preflight inspection and properly secure a fuselage cowling panel that struck a tail rotor blade, resulting in a subsequent failure of the tail rotor drive system. Factors in this accident were an…NTSB CHI94LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Little Falls, MNan improper preflight by the pilot-in-command and the pilot's failure to maintain airspeed during a turn. A factor associated with the accident was contaminated fuel.NTSB ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.NTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.NTSB NYC94LA043Accident · No injuriesLimited investigationFinal reportBeech A-36-TC · Hillsboro, NHLoss of engine power for undetermined reasons.NTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.NTSB LAX94FA081Accident · 1 fatalField investigationFinal reportGolightly RV-4 · La Verne, CAa loss of engine power due to the improper maintenance and installation of the fuel system lines and fittings, and the pilot's failure to ensure the engine fuel primer was locked prior to takeoff. An additional cause was the pilot's failure to maintain…NTSB FTW94LA056Accident · No injuriesLimited investigationFinal reportBeech 35 · Crystal Beach, TXWas a total loss of engine power for undetermined reasons. Factors were a passenger door inadvertently opening in flight due to inadequate preflight by the pilot, unsuitable terrain for the forced landing, and carburetor icing conditions.NTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.NTSB MIA94LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Atlanta, GAFailure of the pilot-in-command to apply power after the airspeed decrease just before touchdown and also failure to recover from the bounced landing. Contributing to the accident was the in-flight encounter with wind gusts while on approach to land.NTSB LAX94LA080Accident · 2 fatalLimited investigationFinal reportCessna 150G · Truckee, CAThe pilot's impaired judgment and impaired performance, while under the influence of drugs, that resulted in his failure to maintain sufficient altitude and clearance above the mountainous terrain and obstructions (power line & trees).NTSB LAX94LA079Accident · 1 fatalLimited investigationFinal reportAero Commander 100 · Chico, CAIssuance of an improper (special VFR) clearance by the tower controller, while the visibility was less than one mile, continued VFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain control of the…NTSB ATL94LA031Accident · 2 fatalLimited investigationFinal reportCarson Piel Emeraude CP305 · Morrison, TNThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's improper…NTSB NYC94LA044Accident · No injuriesLimited investigationFinal reportMooney 20E · Linden, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel and resulted in the loss of engine power.NTSB LAX94LA078Accident · No injuriesLimited investigationFinal reportBell 206B · Las Vegas, NVthe pilot's failure to properly position the helicopter away from the dolly edge during the initial touchdown.NTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.NTSB FTW94LA053Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Giddings, TXThe pilot's failure to maintain main rotor RPM. The weather conditions and delayed application of carburetor were factors in the accident.NTSB CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.