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 FTW91LA103Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Brighton, AR(1) The pilot's failure to maintain adequate clearance from the wires and (2) the wire's subsequent interference with the flight controls.NTSB FTW91LA101Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Kingsland, TXThe pilot's failure to follow procedures. A factor was the pilot's lack of expereince in seaplanes.NTSB FTW91FA104Accident · 1 fatalField investigationFinal reportCessna C182R · Big Spring, TXThe pilot's failure to recover from an aerobatic maneuver due to insufficient altitude.NTSB DEN91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Englewood, COThe pilot's failure to maintain visual lookout. A factor was: the pilot's improper use of the throttle controls and brakes.NTSB CHI91LA196Accident · No injuriesLimited investigationFinal reportCessna 172RG · Hawley, MNInattentiveness of both the flight instructor and the student pilot, and failure to use carburetor heat. A factor related to the accident is the unsuitable terrain encountered during the forced landing.NTSB ANC91LA077Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Woods River, AKFailure of the pilot to maintain adequate airspeed, while turning after a low pass, which resulted in an inadvertent stall. The wind gusts and turbulence were related factors.NTSB NYC91FA154Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Millinocket, MEFailure of the pilot to maintain adequate airspeed, while maneuvering for a precautionary landing on a road, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper replacement of an oil temperature gage, and a…NTSB MIA91WA164Accident · 4 fatalForeign investigationGulfstream G-1159A · Caracas, VenezuelaNTSB LAX91LA265Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2-RG · Visalia, CATotal loss of engine power due to the failure of the number 4 engine exhaust valve.NTSB FTW91LA102Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Lancaster, TXThe pilot's failure to recover from a bounced landing. A factor was the gusting winds.NTSB CHI91LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Cadillac, MIImproper preflight, inattentiveness, failure to maintain airspeed, and poor inflight planning/decision.NTSB CHI91DTG02Accident · No injuriesFinal reportSikorsky H-19-UH19D · Mcclusky, NDFailure of the engine blower/supercharger assembly. A factor related to the accident was: no suitable terrain in which to make an immediate emergency landing.NTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.NTSB ANC91LA076Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC-65 · Kakhonak, AKThe uncertificated pilot failed to maintain aircraft control during the initial climb and the physical impairment by drugs (marijuana) of the pilot. Contributing to the accident was the stall which was not identified by the nonrated pilot.NTSB SEA91LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Corvallis, ORThe student pilot's overconfidence in his personal ability and inadquate remedial action. Contributing to the accident was his decision to attempt a solo autoroation.NTSB MIA91TL#05Accident · No injuriesClass 3Final reportBell 206L3 · Opa-Locka, FLNTSB LAX91LA264Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Phoenix, AZThe failure of the student to maintain the proper rotor RPM while performing a practice autorotation, and, the failure of the flight instructor to properly supervise the conduct of the flight and to take timely corrective action.NTSB LAX91LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Oceanside, CAFuel exhaustion due to the pilot's improper preflight planning.NTSB FTW91LA098Accident · Serious injuriesLimited investigationFinal reportSikorsky S76A · Ship Shoal 290kThe copilot's reduction of power to ground idle on both engines. Factors were the pilot's poor landing technique and his failure to establish adequate crew coordination.NTSB FTW91DRA04Accident · No injuriesFinal reportCessna 188B · Wallis, TXThe partial power loss during a critical phase of flight. A factor was the lack of suitable terrain onto which a successful forced landing could have been executed.NTSB CHI91DER06Accident · No injuriesFinal reportPiper PA-36-285 · Fergus Falls, MNThe pilot's failure to maintain adequate clearance from obstacles during aerial apllication operations.NTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.NTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.NTSB SEA91LA138Accident · Minor injuriesLimited investigationFinal reportCessna C175 · East Glacier, MTThe pilot's failure to maintain sufficient airspeed. Contributing to the accident was: the gusty wind conditions and the pilot's lack of experience in this type of operation.NTSB SEA91LA134Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Rock Springs, WYThe pilot's inadequate preflight planning and decision to attempt flights in unfavorable environmental codnitions. The environmental conditions were factors in the accident.NTSB SEA91LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Pleasant Grove, UTThe pilot's failure to maintian proper airspeed while on final approach.NTSB LAX91LA274Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Santa Maria, CAOil starvation due to the pilot's failure to properly configure the aircraft for the flight during the preflight inspection.NTSB LAX91LA261Accident · No injuriesLimited investigationFinal reportCessna T-210 · San Carlos, CAThe pilot-in-command's failure to maintain directional control on landing. Factors related to the accident were the pic's inadequate compensation for wind conditions and improper recovery procedures from a bounced landing.NTSB LAX91LA260Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Sonita, AZA loss of engine power due to a broken piston ring in the number 3 cylinder, which resulted in the aircraft's inability to maintain level flight.NTSB FTW91LA099Accident · No injuriesLimited investigationFinal reportChampion 7FC · Medina, TXThe pilot's inadequate visual lookout.NTSB DEN91LA085Accident · No injuriesLimited investigationFinal reportCessna 172J · Rifle, COThe student pilot improperly flared the aircraft during landing.NTSB DEN91LA084Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lafayette, COThe pic's abrupt touchdown. Factors were: approach reference speed not maintained, proper descent rate not maintained by the PIC and inattention by the designated examiner.NTSB CHI91LA194Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mundelein, ILThe pilot in command's not maintaining visual contact with the previously identified airplane.NTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.NTSB CHI91LA192Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marquette, MIThe pilot-in-command's failure to maintain proper altitude.NTSB CHI91LA180Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNBecause of inadequate compensation for the wind conditions, aircraft control was lost by the pilot. A factor related to the accident was a gusty crosswind landing environment.NTSB CHI91DTG03Accident · No injuriesFinal reportSchweizer G164 · Gwinner, NDInadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.NTSB CHI91DEP10Accident · No injuriesFinal reportAllan R. Goldman Dragonfly · Kenosha, WIInadequate aircraft design and insufficient information regarding wing versus canard angle for an amateur built aircraft.NTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.NTSB BFO91LA055Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Philadelphia, PAFailure of the pilot to ensure cabin crew members were prepared for an encounter with turbulence.NTSB ANC91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKThe pilot's failure to use proper takeoff procedures. Contributing to the accident was the tailwind, and the rising terrain.NTSB SEA91LA132Accident · Minor injuriesLimited investigationFinal reportDuffy Smith Mini Plane · Ogden, UTA premature liftoff and subsequent stall.NTSB SEA91FA131Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nephi, UTPoor inflight planning and decisions. Factors to the accident were: an uncontrolled stall/spin, and inadequate airspeed.NTSB NYC91DHA02Accident · Minor injuriesFinal reportVans RV-4 · Manville, NJThe pilot's failure to maintain directional control of the airplane after an aborted landing, which resulted in the airplane colliding with a mound of dirt off the runway.NTSB LAX91LA263Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain Hills, AZThe failure of the student pilot and instructor pilot to correctly configure the aircraft for the attempted go around. Contributing to the accident was the improper supervision of the flight by the flight instructor.NTSB FTW91LA100Accident · No injuriesLimited investigationFinal reportCessna 150 · Berryville, ARThe loss of engine power for unknown reasons and the pilot's improper flare which resulted in a hard landing.NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB ATL91LA111Accident · 1 fatalLimited investigationFinal reportRider-Charles Aerosport Scamp · Raeford, NCThe pilot's improper adjustment of the engine carburetor, and his operation of the aircraft with a known powerplant deficiency. Factors in this accident were: the lack of spring tension for the fuel mixture, and the fouled condition of the engine spark plugs.NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.