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 MIA91LA217Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Penuelas, PRInadvertent control interference by a passenger shortly after takeoff resulting in the loss of control and roll over after touchdown.NTSB LAX91LA395Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Tehachapi, CAFuel exhaustion due to improper inflight planning.NTSB FTW91LA161Accident · Serious injuriesLimited investigationFinal reportBarnes AX 7 · Baytown, TXThe crewmembers improper posture during landing which led to a serious injury.NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB CHI91FA294Accident · 3 fatalField investigationFinal reportBell-K Copter 47D1 · Laurie, MOPoor judgement of the pilot, due to impairment from consumption of alcoholic beverage before flight, his intentional buzzing, and his inadequate visual lookout (failure to see-and-avoid power lines).NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB MIA91LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Yazoo City, MSSeparation of the right main landing gear during take off due to failure of the bolts which secure the gear to the airframe. Contributing to the accident was the failure of the pilot to abort the takeoff.NTSB LAX91LA405Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Keaau, HIThe pilot's landing hard. A contributing factor in this accident was the aircraft emitting a vibration from an unknown source.NTSB LAX91LA396Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's failure to maintain directional control of the airplane. Contributing factors related to the dark, night light condition and to the pilot's inexperience in the type of nighttime takeoff operation.NTSB LAX91FA394Accident · 2 fatalField investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate weather evaluation and poor inflight planning/decision. The pilot's impairment due to the use of drugs was a factor in the accident.NTSB LAX91FA393Accident · 3 fatalField investigationFinal reportCessna T210L · Lakewood, CAAn undetermined loss of engine power and the pilot's failure to maintain airspeed during the forced landing.NTSB CHI91LA300Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Muskegon, MIThe failure, for reasons unknown, of the number four bearing in the high pressure spool of the engine.NTSB CHI91LA287Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Lake Elmo, MNA loss of engine power for undetermined reasons. A factor contributing to the accident was the unsuitable terrain on which the pilot had to land.NTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB BFO91LA083Accident · No injuriesLimited investigationFinal reportCessna 152U · Burnt Chimney, VAImproper planning/decision by the pilot. The uphill runway and obstructions (trees) near the departure end of the runway were related factors.NTSB BFO91LA082Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Venus CM · New Castle, VAThe pilot's failure to maintain adequate airspeed which resulted in a stall mush. Contributing was a high density altitude causing deteriorated aircraft performance, and an inadequate preflight preparation which resulted in an overgross aircraft condition.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.NTSB ANC91FA147Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Wasilla, AKA loss of control in flight due to improper loading of the airplane.NTSB NYC91LA238Accident · No injuriesLimited investigationFinal reportCessna 182RG · Robbinsville, NJA detached heli coil from the number 6 cylinder, resulting in a loss of engine power and subsequent forced landing in a corn field.NTSB NYC91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Johnstown, PAA collision with a deer while landing. A factor related to the accident was night conditions which restricted the pilot's view of the deer until it was within the illumination of the landing light.NTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.NTSB SEA91LA233Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miltonfreewater, ORPilot factor in that the pilot failed to insure there was adequate clearance from obstacles for a safe takeoff. A factor to the accident was: the pilot's poor preflight planning/preparation.NTSB NYC91LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · Norwood, MAPremature retraction of the wing flaps during a go-around which resulted in an inadvertent stall with insufficient altitude for recovery. Factors related to the accident were: the pilot's lack of total experience in make and model, and lack of recent…NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.NTSB LAX91LA391Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Kahului, HIThe student pilot entry into an uncontrolled descent while attempting to perform an autorotation. The student pilot's lack of total experience was a factor in the accident.NTSB DEN91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKPower loss due to fuel exhaustion and the pilot's failure to refuel. A factor was: the rough uneven terrain.NTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.NTSB ANC91LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThat the pilot inadvertently stall/spun the airplane to the ground. Contributing to the accident was the pilot's failure to adequately remove the ice/frost from the wings before starting the takeoff.NTSB ANC91LA149Accident · No injuriesLimited investigationFinal reportChampion 7AC · Skwentna, AKThe pilot's failure in not maintaining aircraft control on landing. Contributing to the accident was the rough, uneven terrain and a wet and slick landing area.NTSB SEA91LA232Accident · No injuriesLimited investigationFinal reportCessna 140 · Gates, ORThe student pilot's excessive remedial action. Factors to the accident were poor supervision by the CFI.NTSB LAX91LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAA stuck exhaust valve due to the operator's non compliance with a manufacturers recommended service bulletin on the engine. Contributing to the accident was the lack of suitable terrain for a safe landing.NTSB LAX91LA388Accident · 1 fatalLimited investigationFinal reportTexas Helicopter M74 · Farmington, CALoss of engine power for an undetermined reason. Factors related to the accident were: the excessive gross weight of the helicopter, and the pilot's improper use of flight controls due to impairment from use of a drug (marijuanna).NTSB FTW91LA160Accident · 1 fatalLimited investigationFinal reportCessna 150L · Collinsville, OKThe inadvertent stall by the pilot. A factor was the improper departure flap setting.NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB DEN91FA127Accident · 2 fatalField investigationFinal reportButler Aerostar 600 · Ruidoso, NMLoss of control in flight after to the cabin door opened inadvertently during takeoff run.NTSB DEN91FA126Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ft. Carson, COThe loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB CHI91FA291Accident · 2 fatalField investigationFinal reportBeech 95 · Killdeer, NDThe pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…NTSB ANC91LA146Accident · No injuriesLimited investigationFinal reportHughes 369D · Iliamna, AKWas fuel exhaustion due to the pilot-in-command's improper preflight planning. Contributing to the accident was the rough and uneven tundra landing site.NTSB NYC91LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Easton, PAAn overrun after the pilot-in-command landed long on a short, wet runway. A factor related to the accident was the failure of the pilot to make a go-around.NTSB LAX91LA390Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Chula Vista, CAThe pilot's failure to maintain the proper airspeed and misjudging the landing flare altitude. The powerplant failure for an undetermined reason and the unsuitable terrain for the float equipped helicopter were factors in the accident.NTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.NTSB CHI91DCA03Accident · No injuriesFinal reportSchweizer G164B · Gideon, MOA binding landing gear brake. A factor related to the accident was the pilot's subsequent inability to maintain directional control.NTSB CHI91DCJ08Accident · No injuriesFinal reportCessna 188B · Belgrade, NEThe pilot's failure to take adequate remedial action. A related factor is the premature liftoff.NTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.NTSB NYC91LA232Accident · No injuriesLimited investigationFinal reportPiper PA46-350P · Dayton, OHA malfunction of the elevator trim indicator and incorrect position of the trim tab which resulted in the pilot aborting the takeoff and a loss of directional control on the ground.NTSB NYC91LA231Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC/2D · Rangeley, MEImproper takeoff planning by the pilot which resulted in an inflight collision with trees during initial climb. A factor related to the accident was the pilot's decision not to use the full lake surface available for takeoff.NTSB LAX91LA387Accident · 1 fatalLimited investigationFinal reportRotorway Exec 90 · Phoenix, AZUndetermined.