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 LAX07LA005Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Upland, CADisconnection of the throttle control linkage due to improper maintenance, which resulted in a loss of engine power during initial climb.NTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.NTSB DEN07WA005Accident · No injuriesForeign investigationCirrus Design SR22 · Karlsruhe-Baden, GermanyNTSB CHI07LA005Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Lake Village, INInadequate visual lookout by the pilot. A factor associated with the accident was that neither airplane was equipped with communications equipment.NTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB NYC07CA002Accident · No injuriesData collectionFinal reportCutler VariEze · Perkasie, PAThe pilot's excessive rotation on takeoff, which resulted in a propeller blade strike, and subsequent forced landing to a field.NTSB MIA07WA001Accident · Serious injuriesForeign investigationPiper PA-23-250 · Arklins Island, BahamasNTSB MIA07CA002Accident · Minor injuriesData collectionFinal reportCessna 172C · Jay, FLThe pilot's improper in-flight planning and decision resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.NTSB ATL07LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Alabaster, ALThe jammed landing gear hydraulic motor shuttle valve.NTSB SEA07LA005Accident · Minor injuriesLimited investigationFinal reportHatcher Fisher Celebrity · Anacortes, WAA loss of engine power during takeoff for undetermined reasons.NTSB NYC07CA004Accident · No injuriesData collectionFinal reportBeech BE-58 · Annapolis, MDThe pilot's improper in-flight decision to attempt to land on the wet runway, which resulted in an overrun. Factors in the accident were rain, and the gusty wind conditions.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.NTSB DFW07IA018Incident · No injuriesIncident investigationFinal reportBell 206-L4 · Abbeville, LAA fire in the baggage area for undetermined reasons.NTSB DFW07CA001Accident · Serious injuriesData collectionFinal reportChampion Citabria · Slidell, TXThe pilot's failure to maintain clearance from a parked vehicle.NTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.NTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.NTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB DEN07WA004Accident · Serious injuriesForeign investigationAgusta-Bell AB 206A · Villamblard, FranceNTSB ANC07WA002Accident · Minor injuriesForeign investigationBell 206L · Colville Lake, CanadaNTSB DEN07FA003Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Tucumcari, NMThe pilot's failure to maintain aircraft control during aerobatic flight, resulting in an inadvertent accelerated stall. Contributing factors include the low altitude for recovery from the loop and the high density altitude.NTSB DEN07FA002Accident · Minor injuriesField investigationFinal reportBeech 36 · Centennial, COthe loss of engine power for undetermined reasons. Contributing factors were the light pole and parked vehicles impacted during the forced landing.NTSB ATL07LA001Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Somerville, TNThe total loss of engine power for undetermined reasons.NTSB NYC07LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hammonton, NJDisplacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.NTSB SEA07LA002Accident · No injuriesLimited investigationFinal reportCessna 340A · Kalispell, MTThe fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.NTSB LAX07LA002Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIInadvertent application of the lateral cyclic friction, which resulted in a loss of control and subsequent hard landing.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB SEA07LA001Accident · Minor injuriesLimited investigationFinal reportOneil Oneil Glassair II-S · Richland, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Trees were a factor during the landing roll.NTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.NTSB DEN07CA001Accident · Minor injuriesData collectionFinal reportBrantly Helicopter B-2 · Arkansas City, KSthe pilot's failure to maintain aircraft control during takeoff. A contributing factor was the low rotor RPM.NTSB CHI07CA001Accident · No injuriesData collectionFinal reportCessna 180K · Barton City, MIThe pilot's failure to attain a proper touchdown point and his inadvertent selection of a downwind runway, which resulted in the overrun. A contributing factor was the tailwind encountered during landing. Additional factors were the wet, turf runway, and the…NTSB ANC06LA144Accident · No injuriesLimited investigationFinal reportCessna TU206A · Juneau, AKThe separation of the number 6 cylinder assembly from the engine during cruise flight, which resulted in a hard forced landing in rough ocean swells. A factor contributing to the accident was the rough ocean swells.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB CHI06CA277Accident · No injuriesData collectionFinal reportRockwell 112TC · Bolivar, MOThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the go-around attempt. Contributing factors were the crosswind and the gusts.NTSB ATL06LA133Accident · No injuriesLimited investigationFinal reportRobinson R44 · Beaufort, NCThe loss of engine power for undetermined reasons.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB NYC06LA231Accident · No injuriesLimited investigationFinal reportMooney M-18L · Lexington, KYThe failure of both magnetos which resulted in a loss of engine power during cruise flight.NTSB DFW06CA217Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Carrizo Springs, TXThe loss of engine power due to a malfunction of the electric fuel pump. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DCA06RA076Accident · 154 fatalForeign investigationBoeing 737-800 · Azevedo, BrazilNTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…NTSB ATL06CA131Accident · No injuriesData collectionFinal reportBeech A36 · Macon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing.NTSB LAX06CA299Accident · Minor injuriesData collectionFinal reportBeech 95-55 · Safford, AZThe pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.NTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.NTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.NTSB ATL06CA132Accident · No injuriesData collectionFinal reportCessna 180K · Mooresville, NCThe pilot's failure to maintain directional control during the takeoff roll which resulted in a ground loop.NTSB SEA06CA190Accident · No injuriesData collectionFinal reportColtrin RV-6 · Burley, IDA loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.