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 NYC99LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Boston, MAThe belt-loader driver's loss of control of the vehicle, and his failure to follow published procedures for approaching the airplane with the belt-loader.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.NTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.NTSB IAD99LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Medina, OHWas the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.NTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.NTSB NYC99LA235Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · New York, NYInadequate counterbalancing to compensate for the weight of the cargo door.NTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…NTSB DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.NTSB NYC99IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York, NYThe Cessna pilot's incorrect visual identification of the Boeing 737's altitude, and decision to take evasive action that was not required, which resulted in the two airplanes coming within 500 feet horizontally, and 0 feet vertically of one another.NTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.NTSB MIA99LA026Accident · 1 fatalLimited investigationFinal reportSaab-Scania 340A · Memphis, TNThe ground crewmembers inadvertent walking into the path of a rotating propeller resulting in her being struck and fatally injured.NTSB NYC99LA022Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe driver's failure to maintain control of the belt loader. A factor in the accident was the precipitation which may have contributed to the driver's foot slipping off the brake and onto the accelerator, as he approached the airplane.NTSB DEN99TA013Accident · No injuriesFinal reportAir Tractor AT-400 · Aztec, NMThe pilot's inadequate preflight inspection of the airplane. Factors were the unsecured oil dipstick, the loss of engine oil pressure necessitating a precautionary landing on unsuitable terrain, and the collision with the tree.NTSB NYC99LA013Accident · Serious injuriesLimited investigationFinal reportGoodyear Aerospace GZ-20-A · Bedford, MAThe separation of the pull-in-line. A factor in the accident was the gusting winds.NTSB FTW99LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Tomball, TXThe pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.NTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.NTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.NTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.NTSB NYC98LA199Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly AX-9 · Brookhaven, NYThe failure of the passenger to comply with the pilot briefing, and properly brace herself for landing.NTSB LAX98LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Page, AZFailure of the pilot to verify throttle position and/or obtain qualified assistance while hand propping the aircraft engine.NTSB CHI98LA302Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Columbus, INthe pilot-in-commands failure to maintain airspeed and the subsequent stall/mush. Factors associated with the accident were the open baggage door and the inadequate aircraft preflight.NTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…NTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.NTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).NTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.NTSB NYC98LA130Accident · No injuriesLimited investigationFinal reportCessna 172R · Milford, NYThe pilot's decision to intentionally fly below wires, which resulted in the collision with trees. A factor in the accident was the soft grass airstrip.NTSB ANC98LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe failure of the right main landing gear leg due to fatigue cracking. A factor associated with this accident is the inadequate inspection procedure specified by the manufacturer.NTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.NTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.NTSB MIA98LA161Accident · No injuriesLimited investigationFinal reportRevolution MINI-500 · Villa Rica, GAThe pilot's choice of landing area during a precautionary landing adjacent to the runway. This resulted in an in-flight collision of the left skid with a rock during a cyclic flare, loss of directional control, and subsequent collision of the main rotor blade…NTSB FTW98IA196Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-51 · Brownsville, TXThe flightcrew experienced physical impairment resulting from an accumulation in the cockpit of carbon dioxide fumes produced by dry ice, a hazardous material, carried in the main cargo compartment.NTSB MIA98LA148Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLfailure of the flight crew to maintain main rotor RPM during a landing touchdown, which resulted in the main rotor blades contacting the tailboom.NTSB MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.NTSB SEA98IA027Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Eugene, ORA checklist procedure was not followed. The initiation of an evacuation was a factor.NTSB CHI98LA058Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-50 · Memphis, TNthe flight attendant lost his balance during pushback and struck his head on a galley door.NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB CHI98LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cairo, MOa fractured muffler, failure of the owner/pilot to ensured that the annual maintenance inspection had been completed before flight, and subsequent pilot incapacitation due to carbon monoxide poisoning.NTSB MIA98LA031Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6-6 · Elberta, ALa passenger's inadvertent encounter with a rotating propeller.NTSB NYC98LA022Accident · Serious injuriesLimited investigationFinal reportBeech B200 · Norfolk, VAThe passenger tripped for an undetermined reason.NTSB FTW98LA010Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMThe passenger failing to follow the pilot's instructions as to the proper brace position to assume for landing.NTSB FTW98LA008Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Albuquerque, NMthe passenger's failure to follow procedures/directives for the landing.NTSB MIA97LA240Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, NCThe failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.NTSB NYC97LA176Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX-10 · Akron, PAfailure of a passenger to hang onto the ropes, as directed; which allowed another passenger to be struck as the basket tipped over, broking her arm. A related factor was the wind, which was strong enough to tip the basket, while the envelope was deflating.NTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…NTSB CHI97LA268Accident · No injuriesLimited investigationFinal reportBeech G35 · Belleville, MIthe pilot's improper planning/decision by failing to assure that the airplane was either tied down or chocked prior to pulling the propeller through, which started the engine with no one at the controls.NTSB CHI97LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot's decision to perform a precautionary landing in a corn field due to an undetermined event in the cockpit. Factors relating to the accident were: the pilot's inadvertent actuation of the 'smoker' switch, his unfamiliarity with the 'smoke' equipment…NTSB IAD97LA104Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Mt. Vernon, OHThe pilot's failure to maintain rotor RPM.NTSB CHI97LA216Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-8 · Menominee Falls, WIthe slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.