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 ANC03FA066Accident · 5 fatalField investigationFinal reportCessna 421C · Sitka, AKThe pilot's failure to follow IFR procedures by not following the published approach procedures, which resulted in an in-flight collision with terrain. Factors contributing to the accident were a low ceiling, and the pressure induced by conditions/events (the…NTSB MIA03FA130Accident · Serious injuriesField investigationFinal reportBoeing 757-232 · Tampa, FLa torching of the right engine caused by an abnormally high flow fuel during engine start for undetermined reasons. The torching resulted in an unwarranted evacuation of the airplane and serious injuries to three passengers . A contributing factor in the…NTSB NYC03LA143Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Grove City, OHThe passengers failure to maintain her balance inside the balloon basket.NTSB NYC03LA133Accident · Serious injuriesLimited investigationFinal reportMBB BO-105C · Buffalo, NYThe pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.NTSB DEN03IA101Incident · Minor injuriesIncident investigationFinal reportBoeing 757-200 · Dodge City, KSthe inadvertent activation of the flight deck door's upper pressure relief latch during closure of the door, resulting in the deployment of the upper decompression panel which subsequently struck the captain. Contributing factors included the operator's…NTSB LAX03LA157Accident · 1 fatalLimited investigationFinal reportSabre Trike 330 · Jean, NVThe pilot's excessive taxi speed, which resulted in an inadvertent liftoff at an inadequate airspeed and a subsequent stall. A factor was the pilot's lack of experience in the airplane.NTSB CHI03LA136Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Minocqua, WIThe pilot's failure to attain a proper climb rate during takeoff. A factor to the accident was the tree.NTSB LAX03TA150Accident · Serious injuriesFinal reportHughes OH 6A · Pan Tak, AZThe pilot in command's failure to adequately secure loose cargo (a jacket), which resulted in the jacket colliding with the tail rotor during cruise flight, and the subsequent separation of the tail rotor and loss of flight control. A factor associated with…NTSB NYC03LA101Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Boston, MAThe operator's loss of control of the belt-loader while operating in the proximity of the airplane.NTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.NTSB LAX03IA137Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Oakland, CAthe failure of the 1R evacuation slide to inflate because the transport-locking pin had not been removed from the regulator during the slide's installation on the 1R door. The cause of the cabin/cockpit smoke was contamination of the air conditioning packs.NTSB ANC03LA042Accident · No injuriesLimited investigationFinal reportAerospatiale SA-319B · Valdez, AKThe pilot's encounter with a ground resonance condition during the landing touchdown, which resulted in the shearing of a main rotor spacing cable bolt, and buckling of the tail boom.NTSB ANC03LA038Accident · No injuriesLimited investigationFinal reportHughes 369D · Tyonek, AKThe pilot's inadequate visual lookout while lifting into a hover to ensure the helicopter was clear of all objects, which resulted in separation of an external mirror that then struck and damaged a main rotor blade. Factors in the accident were the presence…NTSB NYC03LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Berlin, NJThe pilot's inadequate preflight inspection which led to an unsecured cowling and loss of aircraft control. Factors were the pilot's diverted attention and the unsecured cowling.NTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…NTSB NYC03LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Westerly, RIThe pilot-in-command's delayed remedial action when the airplane flew below the glidepath, and a total loss of engine power for undetermined reasons.NTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.NTSB MIA03LA055Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR72-212 · San Juan, PRThe aft passenger stair handrail collapsing due to undetermined reasons.NTSB ANC03LA030Accident · No injuriesLimited investigationFinal reportCessna 208B · Russian Mission, AKThe failure of the pilot to use a tail stand while loading passengers, which resulted in the airplane's tail impacting the ground.NTSB NYC03LA046Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2B-60 · Cleveland, OHthe bank couriers inadequate visual lookout, as he approached an airplane with operating engines. A factor was the lack of guidance and training from the bank, for working around airplanes with operating engines.NTSB IAD03LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesapeake, VAThe pilot's failure to adequately remove snow and ice from the airplane's wings prior to takeoff.NTSB LAX03IA098Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Kahului, HIthe flight crew's failure to follow the checklist and detect an out of trim condition prior to takeoff.NTSB CHI03LA031Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNThe cabin flight crew not verifying the galley service cart had been properly stowed prior to departure, which resulted in the inadvertent deployment of the galley service cart during initial climb after takeoff.NTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.NTSB NYC03LA016Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Flushing, NYAn inadvertent trauma to the passenger's foot during an emergency evacuation.NTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.NTSB CHI02LA298Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Little Falls, MNThe inadequate starting procedure by the pilot.NTSB LAX02LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Weed, CAThe pilot's failure to follow adequate hand propping engine starting procedures.NTSB FTW02LA255Accident · No injuriesLimited investigationFinal reportCessna 182P · Kirbyville, TXThe pilot's physical impairment due to a previous head injury which resulted in his becoming disoriented. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB ANC02LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Akiak, AKThe unsuitable and soft terrain in the area of a precautionary landing, which resulted in a nose over. Contributing factors in the accident were a false indication of smoke in the airplane during cruise flight, and weather conditions consisting of haze/smoke…NTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…NTSB ATL02LA127Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lawrenceburg, TNThe pilot's failure to secure the fuel cap after refueling that resulted in fuel siphoning from the right main fuel tank and the subsequent fuel supply exhaustion, and the total loss of engine power. The airplane was damaged during the forced landing to a…NTSB ANC02IA093Incident · Serious injuriesIncident investigationFinal reportPiper PA-31-350 · Talkeetna, AKThe passenger's incapacitation during a high altitude flight due to a loss of consciousness as the result of a pre-existing cardiovascular condition. A contributing factor in the incident was the operator's improper use of disposable oxygen masks without a…NTSB NYC02IA117Incident · Minor injuriesIncident investigationFinal reportDornier 328 · Washington, DCThe ground service personnel's failure to follow company procedure, which resulted in the flight attendant sustaining a serious injury.NTSB LAX02LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Henderson, NVThe pilot's misjudged landing flare during an autorotation, which resulted in a hard landing. The pilot's failure to follow the listed emergency procedures in the rotorcraft flight manual and the partial failure of the rotor system's drive belts were factors.NTSB NYC02LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Fairfield, ILThe first officer's abrupt level off.NTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…NTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB FTW02LA138Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Alsatia, LAThe main rotor contact to the tail boom resulting from the pilot leaving the helicopter unattended while the rotors were engaged.NTSB LAX02LA137Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe flight instructor's inadequate remedial action following the onset of ground resonance.NTSB MIA02TA082Accident · Serious injuriesFinal reportAerospatiale SA319B Alouette III · Altoona, FLThe intentional operation of the helicopter with known deficiencies in equipment (inoperative normal brakes), and the pilot's improper use of the cyclic flight controls after the helicopter started rolling following touchdown.NTSB IAD02LA040Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Mount Holly, NJThe pilot's misjudgment of distance, his subsequent improper recovery from a bounced landing, and the failure to maintain airspeed which resulted in an inadvertent stall.NTSB IAD02LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Atlantic Ocean (Atlantic Ocean)The airplane's encounter with turbulence, while climbing to an assigned altitude.NTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…NTSB FTW02LA088Accident · No injuriesLimited investigationFinal reportFokker F-28 MK-100 · Dallas, TXThe ground crew inadvertent application of deicing fluid in the auxiliary power unit resulting in an overspeed and turbine wheel burst. A contributing factor was the gusty wind.NTSB ANC02IA011Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-340-300 · Anchorage, AKThe captain's selection of a taxiway instead of a runway for takeoff and the flightcrew's inadequate coordination of the departure, which resulted in a departure from a taxiway. A factor in the incident was inadequate airline operator's procedures that did…NTSB LAX02LA058Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Winters, CAThe failure of the pilot to retard the engine throttle to idle while hand-propping the engine, which resulted in the engine starting at full (takeoff) power and the airplane taking off with no one aboard.NTSB NYC02LA042Accident · Serious injuriesLimited investigationFinal reportRaytheon BE-1900D · Boston, MAThe passengers misjudged step, which resulted in a loss of balance and subsequent fall.NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…NTSB IAD02LA007Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Dulles, VAA passenger sustained a broken ankle during an emergency evacuation.