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 MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB CHI90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe pilot's improper flare and recovery from a bounced landing.NTSB CHI90DEM01Accident · 1 fatalFinal reportCessna 150E · Grayling, MIA loss of aircraft control for undetermined reasons.NTSB MIA90LA011Accident · No injuriesLimited investigationFinal reportBeech 58P · Jackson, MSThe pilot's misunderstanding of the landing gear emergency extension procedure, which resulted in his inadvertent partial retraction of the gear and failure to land with the gear in the down and locked position. Loss of electrical power was a factor.NTSB MIA90LA010Accident · No injuriesLimited investigationFinal reportBrickman Eipper Mxii · Miami, FLA cracked impulse line to the fuel pump, which resulted in an inoperative fuel pump and fuel starvation. Factors related to the accident were: the vehicles and high obstructions in the emergency landing area, which necessitated a maneuver to avoid their…NTSB FTW90LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, TXThe loss of engine power as a result of a failure of the number 3 exhaust valve due to undetermined reasons. Factors involved in the accident were the previous owner's delay in overhauling the engine and his failure to adhere to the manufacturer's recommended…NTSB FTW90LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Addison, TXThe pilot's decision to continue the taxi during dark night conditions without taxiway lights, an operable landing light or, assistance from airport personnel.NTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.NTSB CHI90DEK01Accident · 1 fatalFinal reportLuscombe 8A · Findlay, OHPilot's failure to maintain control of the airplane following engine failure due to fuel starvation, resulting in a stall/spin. Additional causes were a corroded fuel system & carburetor, improper maintenance/rebuild, operation with known deficiencies in…NTSB NYC90LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Philadelphia, PAThe failure of the pilot of N333TQ to taxi at a speed that would allow him to stop under existing conditions of visibility and taxiway conditions.NTSB NYC90FA011Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Glastonbury, CTThe pilot-in-command's failure to maintain adequate altitude control during maneuvering flight. Contributing to the accident was the failure of the airplane's electrical system and the pilot's operation at night, without emergency lighting (flashlight).NTSB LAX90FA008Accident · 3 fatalField investigationFinal reportBeech F33A · Goodyear, AZThe inflight separation of one propeller blade due to a fatigue fracture of undetermined origin, and failure of the pilot to maintain control of the aircraft during an attempt to return to the runway. A factor in the accident was the oil covered windsheild,…NTSB LAX90DUJ03Accident · Serious injuriesFinal reportHiller UH-12E · Yuma, AZThe pilot misjudged the flare altitude. Contributing to this accident was the failure of the engine torsional coupling which ultimately caused the total loss of power.NTSB DEN90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Ogden, UTAn engine stoppage for undetermined reasons.NTSB NYC90MA009Accident · 5 fatalMajor investigationFinal reportAgusta A109A Mkii · Lacey Township, NJIn-flight separation of a main rotor blade due to fatigue failure of the main rotor blade spar, which originated at a manufacturing induced scratch (tool mark) that was the result of inadequate quality control.NTSB LAX90FA007Accident · Serious injuriesField investigationFinal reportCessna T207A · Grand Canyon, AZThe inflight failure of the airplane's powerplant as a result metal fatigue which allowed the crankshaft to fracture. Contributing to the accident was mountainous terrain of the Grand Canyon which did not allow a suitable forced landing area.NTSB FTW90LA007Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · High Island 474 (Gulf of Mexico)The pilot's attempted takeoff with one tie-down strap still attached to the helicopter which resulted from an inadequatepreflight inspection of the aircraft.NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB SEA90LA004Accident · No injuriesLimited investigationFinal reportCessna 310C · Redmond, ORPoor inflight planning, and the pilot did not maintain a proper glide path on final approach, nor perform proper corrective action. Factors related to the accident were: the pilot's attention was diverted due to an open cabin door and the partial loss of…NTSB NYC90LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, CTA loss of engine power, due to a stuck exhaust valve in the number 4 cylinder. Factors related to the accident were: the pilot's excessive airspeed on final approach, and his failure to attain the proper touchdown point during the landing.NTSB MKC90FA005Accident · 2 fatalField investigationFinal reportPiper PA-28 · Delavan, MNFailure of the pilot to maintain proper altitude during a low pass, and to see-and-avoid obstructions (inadequate visual lookout). Factors related to the accident were: the pilot's ostentatious display and the obstructions (powerlines).NTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.NTSB DEN90LA006Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NMFailure of the pilot to abort the takeoff, when she failed to attain sufficient speed within the appropriate takeoff distance. A factor related to the accident was: high density altitude.NTSB CHI90IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · San Francisco, CAThe extreme wear and eventual failure of a torque tube in the inboard trailing edge flap system. Inspection and lubrication intervals were a factor, as was the physical location of the torque tube with reference to external factors.NTSB NYC90LA007Accident · No injuriesLimited investigationFinal reportCessna 185F · Rockwood, METhe pilot's improper compensation for the gusting crosswind. Contributing factor(s) was: the wind conditions and the pilot's selection of a touchdown point.NTSB LAX90DUJ01Accident · No injuriesFinal reportRoger Nelson Aeronica/T · Sierra Vista, AZThe pilot's inaccurate placement of the aircraft wheels into depressions in a platform mounted on a moving pickup truck during an airshow performance.NTSB FTW90LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Amarillo, TXThe loss of aircraft control by the pilot.NTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.NTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.NTSB CHI90DEE01Accident · Serious injuriesFinal reportBaker/Santiago Pitts S-1S · Dekalb, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB BFO90LA006Accident · No injuriesLimited investigationFinal reportCessna T310Q · Stevensville, MDThe pilot failed to maintain directional control of the aircraft during the landing roll.NTSB ATL90LA005Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Maysville, KYThe improper inspection of the airplanes engine by the pilot/owner resulting in five rocker box cover screws being missing and subsequent loss of engine oil due to the cover vibrating and causing a hole to be worn in it. Subsequent loss of engine power due to…NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.NTSB ANC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Montague Island, AKSelection of unsuitable terrain by the pilot. Contributing factors were: rough terrain, gusty winds, high vegetation, and trees.NTSB NYC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Sterling, MAInflight loss of control due to inadvertent retraction of the wing flaps during a go around.NTSB MKC90LA007Accident · No injuriesLimited investigationFinal reportCessna 182 · Hasty, ARThe engine failure due to fuel starvation resulting from the collapse at the fuel cell. The fact that the forced landing was made in dark night conditions was a factor.NTSB MIA90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Jacksonville, FLInadequate preflight by the pilot, and fuel starvation, due to his improper positioning of the fuel selector.NTSB MIA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Titusville, FLFailure of the pilot to go around after landing long with excessive airspeed.NTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).NTSB LAX90LA006Accident · No injuriesLimited investigationFinal reportPiper J-2 · Santa Ynez, CAFailure of the pilot to adequately secure the aircraft before hand propping the engine.NTSB LAX90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Paso Robles, CAThe student pilot's failure to adequately compensate for the cross wind condition.NTSB FTW90FA005Accident · 5 fatalField investigationFinal reportCessna 208 · Uncertain, TXImproper planning/decision by the pilot-in-command, and failure of the aircrew to maintain runway alignment and clearance from the high obstructions (trees) beside the runway. Related factors were: weather conditions, dark night, lack of runway edge lights,…NTSB CHI90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Toledo, OHFailure of the pilot to maintain directional control, which resulted in a ground swerve. Factors related to the accident were: the crosswind and the pilot's improper compensation for wind condition.NTSB CHI90FA003Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Ann Arbor, MIFailure of the pilot to maintain sufficient airspeed, which resulted in an inadvertent stall. A factor related to the accident was the pilot's lack of experience in the aircraft.NTSB SEA90LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Hoonah, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors related to the accident were: unfavorable/gusty wind conditions and the berm.NTSB SEA90FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech 36TC · MissingUndetermined until the airplane is located.NTSB NYC90LA005Accident · No injuriesLimited investigationFinal reportCessna 170B · Burlington, CTThe aircraft colliding with a steel drum placed on the runway by unknown person(s) to mark a pothole area.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MIA90LA004Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Orlando, FLFailure of the left main landing gear.NTSB MIA90IA005Incident · No injuriesIncident investigationFinal reportMooney M20F · Pensacola, FLImproper rigging of the landing gear which resulted in an overload failure.