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 LAX90LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAFailure of the student pilot to maintain adequate control of the airplane during the takeoff roll.NTSB DEN90LA083Accident · No injuriesLimited investigationFinal reportPeterson KIT FOX Model 1 · Highwood, MTA premature lift-off by the pilot, resulting in a stall/mush.NTSB NYC90FA083Accident · 1 fatalField investigationFinal reportCessna 150F · Lloyd, NYPilot factor in that he was attempting VFR flight in inc conditions and collided with a multipurpose communications tower.NTSB NYC90DNE02Accident · No injuriesFinal reportWalter Hudson Mustang 2 · Westfield, MAAn encounter with wake turbulence from a preceding airplane. A factor related to the accident was the pilot's decision to takeoff close behind the preceeding airplane.NTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.NTSB LAX90LA141Accident · No injuriesLimited investigationFinal reportFairchild SA227AC · Panoche, CAThe pilot's poor judgment in attempting a flight while being fatigued due to the lack of sleep which resulted in a loss of control and subsequent overstressing of the airplane.NTSB LAX90LA132Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Saipan (Pacific Ocean)The partial failure of a rotor system component for undetermined reasons.NTSB DEN90FA085Accident · 2 fatalField investigationFinal reportCessna 421-C · Boulder, COA loss of airplane control as a result control interference by the passenger following a struggle between the pilot and the passenger.NTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.NTSB ATL90LA090Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Jonesboro, GALoss of engine power because of carburetor icing conditions. A factor in the accident was the pilot's improper use of carburetor heat.NTSB ANC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot failed to maintain proper obstacle clearance altitude during his final approach.NTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.NTSB MIA90LA099Accident · No injuriesLimited investigationFinal reportCessna P210N · Natchez, MSThe late extension of the landing gear by the pilot.NTSB MIA90LA098Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Marathon, FLFailure of the pilot to maintain directional control during takeoff, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the pilot's excessive compensation for the wind condition, and his lack of experience in…NTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.NTSB LAX90DUM01Accident · 1 fatalFinal reportFreeman H Easton Falcon XP · Glamis, CAThe pilots loss of control while attempting to return to the airstrip after experiencing a partial loss of engine power.NTSB FTW90LA089Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Durant, OKPilot's failure to maintain adequate airspeed (vso) and subsequent stall of the aircraft at an altitude from which recovery was not possible. A factor in the accident was the pilot's improper procedures for the landing approach.NTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…NTSB ANC90LA050Accident · No injuriesLimited investigationFinal reportMaule M-4 · Anchorage, AKThe pilot's improper compensation for wind conditions and failure to maintain directional control. The unfavorable (variable) wind and snow covered terrain were related factors.NTSB ANC90LA049Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kayak Island, AKThe pilot's failure to use a suitable area to taxi for takeoff. The hidden obstruction (log) was a related factor.NTSB MKC90LA077Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Minneapolis, MNFailure of the pilot to maintain directional control of the aircraft during the landing. The failed (flat) right main tire was a related factor.NTSB MIA90LA097Accident · No injuriesLimited investigationFinal reportCessna 150L · Vieques, PRFailure of packing around the carburetor accelerator pump, which had jammed throttle movement and would not allow an increase in engine RPM above idle.NTSB LAX90LA131Accident · No injuriesLimited investigationFinal reportCessna 172M · Groveland, CAThe pilot improperly used the flight controls during the landing roll-out.NTSB LAX90FA128Accident · 2 fatalField investigationFinal reportCessna P210N · La Verne, CAThe pilot's improper use of powerolant controls which resulted in an excessive rich mixture and power loss. In addition, the pilot failed to maintain adequate airspeed during the forced landing.NTSB CHI90FA105Accident · 1 fatalField investigationFinal reportCessna 152 · Oberlin, OHImproper use of carburetor heat by the dual student, carburetor ice, inadequate supervision to correct the situation by the instructor pilot (CFI), and failure of the CFI to maintain adequate airspeed, which resulted in a stall. Carburetor icing condition was…NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB LAX90DVG03Accident · Serious injuriesFinal reportSmyth Sidewinder Smyth · Georgetown, CAThe failure of the pilot to abort his landing and execute a go-around.NTSB FTW90GA088Accident · 1 fatalFinal reportCessna 337G · Notrees, TXThe pilot's decision to continue VFR flight into known IMC.NTSB ATL90FA093Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Ellijay, GAThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions.NTSB ANC90FA047Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Chevak, AKImproper flare by the pilot (PIC) during the landing/flare. The weather condition with fog was a related factor.NTSB ANC90FA046Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKCarburetor ice due to the pilot's improper use of the carburetor heat. Factors related to the accident were: carburetor icing conditions, unfavorable wind, and the snow covered terrain.NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB FTW90LA087Accident · Serious injuriesLimited investigationFinal reportBeech 100 · Uvalde, TXImproper IFR procedure by the pilot by not maintaining the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: darkness, low ceiling, fog, and rain.NTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.NTSB DEN90LA081Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Grand Junction, COThe pilot's failure to correct a swerve during landing roll.NTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.NTSB ANC90LA044Accident · No injuriesLimited investigationFinal reportCessna 180J · Lake Nikabuno, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.NTSB MKC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Hyannis, NEFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and a subsequent nose over. Factors related to the accident were: the pilot's lack of experience in this aircraft, and the soft terrain.NTSB LAX90LA126Accident · No injuriesLimited investigationFinal reportCessna 180H · San Carlos, CAThe pilot's failure to maintain directional control of the aircraft during the landing.NTSB DEN90LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Price, UTThe pilot's inadequate conpensation for the gusty wind conditions, which were a factor.NTSB ATL90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Buford, GANTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…NTSB NYC90LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer S2-33A · Brookhaven, NYCause of the accident was a hard landing after the pilot stalled the glider while turning onto final approach.NTSB NYC90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Limington, MEFuel starvation, due to carburetor contamination, which resulted in a forced landing in unsuitable terrain.NTSB MIA90WA095Accident · No injuriesForeign investigationBeech H-18 · Nassau, BahamasNTSB MIA90LA096Accident · No injuriesLimited investigationFinal reportBell 47D1 · Rockledge, FLFailure of a connecting rod.NTSB LAX90LA124Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sandy Valley, NVThe pilot's poor flight planning and poor inflight decisions resulting in becoming lost and exhausting fuel before landing.NTSB LAX90DUK01Accident · Serious injuriesFinal reportKolb Twinstar · Halfmoon Bay, CAFailure of the pilot to maintain adequate airspeed and altitude.