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.

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.Oct 13, 1989 · N1012Z · Substantial damageNTSB CHI90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe pilot's improper flare and recovery from a bounced landing.Oct 13, 1989 · N24800 · Substantial damageNTSB CHI90DEM01Accident · 1 fatalFinal reportCessna 150E · Grayling, MIA loss of aircraft control for undetermined reasons.Oct 13, 1989 · N3905U · DestroyedNTSB 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.Oct 12, 1989 · N94JP · Substantial damageNTSB 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…Oct 12, 1989 · N181BB · Substantial damageNTSB 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…Oct 12, 1989 · N6636W · Substantial damageNTSB 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.Oct 12, 1989 · N30263 · Substantial damageNTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.Oct 12, 1989 · N9157S · DestroyedNTSB 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…Oct 12, 1989 · N45895 · DestroyedNTSB 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.Oct 11, 1989 · N333TQ · 2 aircraft · Substantial damageNTSB 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).Oct 11, 1989 · N4106W · Substantial damageNTSB 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,…Oct 11, 1989 · N67536 · DestroyedNTSB 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.Oct 11, 1989 · N689SB · Substantial damageNTSB DEN90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Ogden, UTAn engine stoppage for undetermined reasons.Oct 11, 1989 · N7409E · Substantial damageNTSB 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.Oct 10, 1989 · N21FL · DestroyedNTSB 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.Oct 10, 1989 · N7602U · DestroyedNTSB 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.Oct 10, 1989 · N3889W · Substantial damageNTSB 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.Oct 10, 1989 · N9658A · Substantial damageNTSB 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…Oct 9, 1989 · N1845H · Substantial damageNTSB 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.Oct 9, 1989 · N50165 · Substantial damageNTSB 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).Oct 9, 1989 · N6340R · Substantial damageNTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.Oct 9, 1989 · N8149J · Substantial damageNTSB 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.Oct 9, 1989 · N6029S · Substantial damageNTSB 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.Oct 9, 1989 · N512US · Minor damageNTSB 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.Oct 8, 1989 · N7321H · Substantial damageNTSB 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.Oct 8, 1989 · N101E · Substantial damageNTSB FTW90LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Amarillo, TXThe loss of aircraft control by the pilot.Oct 8, 1989 · N8727D · Substantial damageNTSB 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.Oct 8, 1989 · N3581D · Substantial damageNTSB 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.Oct 8, 1989 · N1059S · Substantial damageNTSB 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.Oct 8, 1989 · N983CS · Substantial damageNTSB BFO90LA006Accident · No injuriesLimited investigationFinal reportCessna T310Q · Stevensville, MDThe pilot failed to maintain directional control of the aircraft during the landing roll.Oct 8, 1989 · N1729H · Substantial damageNTSB 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…Oct 8, 1989 · N1829N · Substantial damageNTSB 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.Oct 8, 1989 · N11575 · Substantial damageNTSB 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.Oct 8, 1989 · N5222X · Substantial damageNTSB NYC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Sterling, MAInflight loss of control due to inadvertent retraction of the wing flaps during a go around.Oct 7, 1989 · N69169 · Substantial damageNTSB 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.Oct 7, 1989 · N11PG · Substantial damageNTSB MIA90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Jacksonville, FLInadequate preflight by the pilot, and fuel starvation, due to his improper positioning of the fuel selector.Oct 7, 1989 · N5252E · Substantial damageNTSB MIA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Titusville, FLFailure of the pilot to go around after landing long with excessive airspeed.Oct 7, 1989 · N9141H · Substantial damageNTSB 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).Oct 7, 1989 · N958VJ · No damageNTSB LAX90LA006Accident · No injuriesLimited investigationFinal reportPiper J-2 · Santa Ynez, CAFailure of the pilot to adequately secure the aircraft before hand propping the engine.Oct 7, 1989 · N6677C · Substantial damageNTSB LAX90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Paso Robles, CAThe student pilot's failure to adequately compensate for the cross wind condition.Oct 7, 1989 · N2515T · Substantial damageNTSB 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,…Oct 7, 1989 · N208W · DestroyedNTSB 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.Oct 7, 1989 · N6306W · Substantial damageNTSB 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.Oct 7, 1989 · N9704J · DestroyedNTSB 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.Oct 6, 1989 · N7193F · Substantial damageNTSB SEA90FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech 36TC · MissingUndetermined until the airplane is located.Oct 6, 1989 · N6773C · DestroyedNTSB 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.Oct 6, 1989 · N727Z · Substantial damageNTSB 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.Oct 6, 1989 · N8222F · Substantial damageNTSB MIA90LA004Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Orlando, FLFailure of the left main landing gear.Oct 6, 1989 · N40340 · Substantial damageNTSB MIA90IA005Incident · No injuriesIncident investigationFinal reportMooney M20F · Pensacola, FLImproper rigging of the landing gear which resulted in an overload failure.Oct 6, 1989 · N52DB · Minor damage