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 SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.NTSB MIA04CA077Accident · No injuriesData collectionFinal reportCessna 172S · Key West, FLThe pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.NTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.NTSB DEN04IA063Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Colorado Spring, COThe failed air conditioning fan by-pass check valve and the subsequent overtemperature of the air conditioning pack.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB NYC04CA108Accident · Serious injuriesData collectionFinal reportAndrews Zenith Tri-Z · Kennedy, NYThe pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.NTSB MIA04LA087Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Port St. Lucie, FLThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent swerve, the right main landing gear wheel separating, and the airplane impacting trees and incurring structural damage.NTSB MIA04LA075Accident · Serious injuriesLimited investigationFinal reportRichard A. Denisar RV-4 · Spring Hill, FLThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power during takeoff/initial climb due to fuel contamination, that resulted in a forced landingNTSB FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.NTSB CHI04CA105Accident · Minor injuriesData collectionFinal reportCessna A185E · Hastings, MNThe pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.NTSB ANC04LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Copper Center, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to utilize carburetor heat, which resulted in a loss of engine power during takeoff initial climb, and a subsequent encounter with snow-covered terrain. Factors contributing to the…NTSB MIA04LA072Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5B · Lakeland, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the airplane departing the right side of the runway, collapsing the left main landing gear, the left wing striking the ground, and the airplane…NTSB MIA04LA071Accident · Serious injuriesLimited investigationFinal reportBeech Be-300 · Daytona Beach, FLThe pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.NTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.NTSB CHI04CA106Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Columbia, MOThe pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…NTSB ATL04CA095Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carthage, TNThe pilot's failure to maintain visual lookout and clearance while maneuvering resulting in an in-flight collision with wires and subsequent collision with water.NTSB NYC04LA107Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Beach Haven, NJAn encounter with turbulence during cruise flight.NTSB FTW04LA116Accident · No injuriesLimited investigationFinal reportCessna 150 · Magnolia, ARThe pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04CA062Accident · No injuriesData collectionFinal reportCessna 180A · Las Vegas, NMthe pilot's decision to takeoff in wind conditions that consisted of a quarterly tailwind and a crosswind in excess of the maximum demonstrated crosswind component, and his failure to maintain directional control.NTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.NTSB NYC04LA105Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Taylor, PAThe failure of the number 2 connecting rod, after a main bearing shift, which resulted in a catastrophic engine failure.NTSB MIA04WA073Accident · 2 fatalForeign investigationCessna 310P · Caracas, VenezuelaNTSB LAX04FA187Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Concord, CAa loss of engine power due to improper maintenance repair procedures and use of improper parts.NTSB LAX04CA186Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAthe student pilot's inadequate flare, which resulted in a hard landing and porpoise.NTSB FTW04LA108Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Goliad, TXThe pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.NTSB LAX04CA185Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Grass Valley, CAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Factors in the accident were wind gusts and tailwind/crosswind conditions.NTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.NTSB ATL04FA093Accident · 3 fatalField investigationFinal reportCessna 182S · North Augusta, SCThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and subsequent in-flight collision with trees and the ground.NTSB NYC04TA103Accident · No injuriesFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)The failure of the number two upper forward right engine cowling attachment, which resulted in substantial damage to the right inboard elevator. A factor was the inadequate procedures in the airliner maintenance manual.NTSB DEN04IA060Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2C10 · Denver, COThe total failure of the airplane's number 1 system hydraulic pump.NTSB ANC04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's loss of directional control during the landing roll, which resulted in the airplane entering deep snow alongside the runway, and nosing over.NTSB SEA04LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hardin, MTThe pilot's failure to perform a go-around. Contributing factors were the pilot's misjudgment of speed and distance and the tree.NTSB SEA04CA068Accident · No injuriesData collectionFinal reportYakovlev Yak 54 · Friday Harbor, WAThe pilot's failure to properly align with the runway. Factors include rough/uneven terrain, inadequate preflight planning and diminished forward visibility.NTSB NYC04CA104Accident · No injuriesData collectionFinal reportCessna 172N · Bridgeport, CTThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control which resulted in a hard landing. A factor was the gusty winds.NTSB MIA04LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · N. Lauderdale, FLThe erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.NTSB MIA04LA067Accident · No injuriesLimited investigationFinal reportCessna 206 · Clewiston, FLThe failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.NTSB LAX04LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · San Jose, CAthe pilot's encounter with jet blast effects. Factors in the accident were the pilots' inadequate situational awareness of the potential for the jet blast encounter after hearing the Global Express airplane on the frequency call ready for taxi, and, the…NTSB IAD04LA016Accident · 2 fatalLimited investigationFinal reportPilatus P3-05 · Edgewater, FLThe delamination of the no. 2 connecting rod bearing for undetermined reasons, resulting in a total loss of engine power. A factor in the accident was the pilot's inability to complete a successful forced landing due to oil on the windscreen, and smoke and…NTSB FTW04CA106Accident · No injuriesData collectionFinal reportCessna 172K · Bogalusa, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI04LA126Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · St. Louis, MOThe inadvertent encounter with turbulence which resulted in the injury to the flight attendant.NTSB CHI04LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · New Munster, WIVisual lookout not maintained by the pilots of both airplanes.NTSB NYC04LA106Accident · No injuriesLimited investigationFinal reportCessna 182S · Plainville, CTThe failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.NTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.NTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB IAD04CA015Accident · No injuriesData collectionFinal reportWaco ASO · Lexington, KYThe pilot's inadequate remedial action to wake turbulence. A factor was the pilot's failure to recognize that the takeoff conditions were conducive to wake turbulence.NTSB DEN04IA059Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COarcing of the windshield deicing system. Factors contributing to the incident were the improper inspection of the windshield's exterior seal, deterioration of the windshield seal, and water penetration through the deteriorated seal.NTSB CHI04LA103Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Marion, INThe pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.NTSB LAX04LA191Accident · No injuriesLimited investigationFinal reportNorth American Aviation Div. Navion · Page, AZthe pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush in high density altitude conditions.NTSB LAX04CA181Accident · No injuriesData collectionFinal reportPiper PA-38-112 · McKinleyville, CAa loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…NTSB FTW04CA107Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Friona, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were prevailing crosswind, rain, and the restricted vision from water on the windscreen, and a vehicle parked near the runway.