NTSB investigations
902 cases where the first occurrence was “Miscellaneous/other”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 ANC96LA083Accident · No injuriesLimited investigationFinal reportChampion 7AC · Clear, AKthe pilot's inadequate preflight inspection in that he failed to ensure that the cabin door was properly secured for takeoff. Factors associated with the accident were: the open cabin door and rough/uneven terrain.NTSB FTW96TA222Accident · No injuriesFinal reportMcDonnell Douglas MD-520N · Bethany, OKThe main rotor blades' contact with the tail boom due to gusting winds during rotor deceleration.NTSB FTW96LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Ft. Lupton, COthe pasenger's failure to follow the instructions given by the pilot during a briefing.NTSB FTW96LA194Accident · No injuriesLimited investigationFinal reportChampion 7AC · Pine Bluff, ARthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB FTW96LA172Accident · No injuriesLimited investigationFinal reportCessna 305A · Erie, COentanglement of the tow banner during banner pickup, and subsequent failure or inability to jettison the banner. A factor relating to the accident was: high gusty wind condition.NTSB SEA96FA071Accident · Minor injuriesField investigationFinal reportCessna U206E · Renton, WAthe pilot's initiation of a flight with a known disqualifying heart condition, and his subsequent inflight incapacitation from a heart attack. A factor relating to the accident was: the inability of the non-rated passenger (unqualified person) to attain a…NTSB FTW96FA143Accident · 1 fatalField investigationFinal reportCessna 150 · Muleshoe, TXimproper planning/decision by the student pilot, and his failure to take adequate remedial action after becoming lost and encountering a low fuel situation, which subsequently resulted in fuel exhaustion, loss of engine power, and a forced landing at night.…NTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.NTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.NTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.NTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.NTSB LAX96LA093Accident · 1 fatalLimited investigationFinal reportBell 47-G5 · Pope Valley, CAthe pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.NTSB FTW96LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Decatur, TXthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB BFO96LA031Accident · Minor injuriesLimited investigationFinal reportBellanca BL14-19-3 · Toledo, OHan improper splice of the magneto 'P' lead wires, and the pilot's improper positioning of the throttle and mixture controls while he rotated the propeller by hand.NTSB ANC96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kasilof, AKThe pilot's inadvertent liftoff, and an inoperative elevator that became jammed due to frozen slush/snow.NTSB BFO96LA024Accident · No injuriesLimited investigationFinal reportCessna 210J · Bellefontaine, OHThe pilot unknownly left the ignition switch in right magneto-only position, while moving the propeller by hand, which allowed an inadvertent start of the engine. The weak battery was a related factor.NTSB CHI96LA025Accident · No injuriesLimited investigationFinal reportBeech A90 · Wichita, KSfailure of the pilot to follow procedures/directives regarding the entrance door, which resulted the door coming open in flight.NTSB LAX96LA035Accident · Serious injuriesLimited investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)the failure of the passenger to comply with the fasten seatbelt signs and the verbal directives of the flight and cabin crew.NTSB LAX96IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 737-5H4 · Las Vegas, NVThe flying pilot's inadvertent exposure to an unidentified ground-based laser beam. A factor in the incident is the lack of appropriate standards by the FAA and FDA for laser light exposure levels to aircrew in navigable airspace.NTSB FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB SEA96LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Laurel, MTthe student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.NTSB MIA95IA238Incident · Minor injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLInadequate written maintenance procedures addressing steps to be followed in the event of a component failure during an engine wash. The emergency slides failed to deploy due to improper installation by company maintenance personnel.NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.NTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.NTSB FTW95LA309Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Belen, NMThe parachutist's failure to follow procedures on exiting the aircraft. A factor was the parachutist's incapacitation due to hitting his head on the doorway floor.NTSB MIA95TA188Accident · No injuriesFinal reportMcDonnell Douglas H369 · Panama City, FLThe pilot-in-command's improper aft application of cyclic control during a simulated touchdown autorotation on landing flare touchdown, resulting in the main rotor blades colliding with the tail boom assembly. Contributing to the accident was the improper…NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB CHI95LA197Accident · Minor injuriesLimited investigationFinal reportGriner Bushby Mustang I · Shelbyville, INthe pilot's allowing the airplane to inadvertently liftoff. A factor was a malfunction of the flight control system.NTSB MIA95IA134Incident · Serious injuriesIncident investigationFinal reportBoeing 727-227 · Brooksville, FLAn elderly passenger losing his balance as the aircraft operated in smooth air.NTSB BFO95FA050Accident · 1 fatalField investigationFinal reportCessna 172F · Tappahanock, VAThe student pilot's misjudgment of distance/speed during the approach to land, and her failure to go around while there was still sufficient runway remaining. Factors related to the accident were: inadequate supervision by the flight instructor, the student's…NTSB BFO95LA046Accident · No injuriesLimited investigationFinal reportSchweizer SC2-33A · North Adams, MAthe failure of the tow rope during the initial climb. Related factors are the gusty wind conditions, the low altitude at which the failure occurred, the tailwind during the emergency landing roll, and the CFI's intentional ground loop due to the obstacle…NTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.NTSB ATL95LA080Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Brownsboro, ALThe student pilot's inadvertent use of spoilers during takeoff. Factors related to the accident were: the glider instructor's failure to identify the extended spoilers, and the proximity of trees in the emergency landing area.NTSB NYC95LA083Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Jamaica, NYexcessive flames/tailpipe fire from the number 2 engine for an unknown reason, which required an emergency evacuation.NTSB FTW95IA148Incident · 1 fatalIncident investigationFinal reportDouglas DC-9-32 · Abilene, TXIncapacitation of the first officer due to a heart attack.NTSB FTW95LA103Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · Dallas, TXThe flight attendants' lack of supervision of deplaning passengers. A factor was lack of supervision by accident victims mother.NTSB MIA95LA058Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Natchez, MSInadequate preflight of the helicopter by the pilot for his failure to separate the dolly before attempting flight.NTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…NTSB CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.NTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.NTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.NTSB FTW94FA279Accident · No injuriesField investigationFinal reportDassault DA 200 · New Orleans, LAThe captain's decision to abort the takeoff after accelerating past V1. A factor was the fluctuating engine instrument for undetermined reasons.NTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…NTSB MIA94LA195Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Merritt Island, FLFailure of the pilot to visually verify that the tow rope was not wrapped around any flight control surface and the inadvertent stall/spin. Contributing to the accident was the entanglement of the tow equipment with the rudder horn, rudder movement was…NTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.NTSB NYC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ellisburg, NYA fuel or fuel system problem that was probably related to the pilot/owner's failure to assure proper maintenance and/or inspection of the airplane before flight. A factor related to the accident was: soft terrain in the emergency landing area.