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 DEN05IA046Incident · Minor injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe tug driver's failure to maintain operational control of the tug, resulting in impact with an airplane. Contributing factors include the tug driver's improper procedure, the tug driver's inadequate initial ground equipment training, and the…NTSB DFW05LA047Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Austin, TXThe failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.NTSB NYC05CA035Accident · Minor injuriesData collectionFinal reportRaytheon Corporate Jets 400A · Cleveland, OHThe loss of directional control by the operator of a ground service vehicle.NTSB NYC05FA026Accident · No injuriesField investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe flightcrew's inadvertent engagement of the autothrottle system, and their failure to recognize the engagement during landing, which resulted in a runway excursion. Factors were the lack of autothrottle switch guards, lack of an autothrottle engagement…NTSB CHI05FA038Accident · 2 fatalField investigationFinal reportHamburger Flugzeugbau HFB 320 Hansa · Chesterfield, MOThe maintenance facility failed to properly install and inspect the elevator trim system resulting in the reversed elevator trim condition and the pilot's failure to maintain clearance with the terrain. Contributing factors included the dark night and low…NTSB CHI05LA014Accident · 1 fatalLimited investigationFinal reportCessna P206B · Taylorville, ILAircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.NTSB DEN05CA010Accident · Serious injuriesData collectionFinal reportAerostar International S-60S · Albuquerque, NMthe passenger striking the pilot's leg during the landing, resulting in a fractured leg.NTSB SEA04LA178Accident · Serious injuriesLimited investigationFinal reportHelio H800 · Fossil, ORThe pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.NTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.NTSB NYC04LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Pittstown, NJThe pilot's failure to obtain a proper climb rate during a go-around, which resulted in a forced landing and subsequent impact with a tree.NTSB DEN04IA124Incident · No injuriesIncident investigationFinal reportBoeing 737-500 · Denver, COthe inaccurate radar information due to the failure of the Airport Movement Area Surveillance radar resulting in the tower calling for the airplane to abort the takeoff, subsequently causing tire and brake damage to the airplane.NTSB FTW04CA205Accident · No injuriesData collectionFinal reportCessna 172N · Cleveland, TXThe student pilot's improper judgment of the airplanes altitude during landing. A contributing factor was the pilot's level of anxiety/apprehension after becoming lost/disoriented.NTSB ANC04LA099Accident · No injuriesLimited investigationFinal reportCessna U206G · Yakutat, AKThe pilot's inadequate preflight inspection, and his failure to secure the cargo door, which resulted in the cargo door coming open during the takeoff roll.NTSB NYC04CA177Accident · Serious injuriesData collectionFinal reportAvian Falcon II · Middletown, OHThe passenger's inadvertent fall from the basket, during landing. A factor in this accident was the windy conditions.NTSB LAX04LA277Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…NTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.NTSB ANC04LA079Accident · No injuriesLimited investigationFinal reportHughes 500D · Iliamna, AKThe ground crew's failure to use proper procedures while securing a sling load to the helicopter, which resulted in foreign object damage to the helicopter's main rotor system while idling.NTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.NTSB ANC04LA077Accident · No injuriesLimited investigationFinal reportHughes 369D · Nome, AKThe pilot's inadequate compensation for wind conditions while the helicopter was standing, which resulted in the coasting main rotor blade contacting the tail boom. A factor associated with the accident was the gusty wind condition.NTSB DCA04IA052Incident · No injuriesIncident investigationFinal reportAirbus Industrie A340-311 · Washington, DCThe incorrect loading of baggage into the aft cargo compartment instead of the forward compartment, which resulted in aft CG light in-flight.NTSB LAX04LA225Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Susanville, CAthe pilot's failure to perform a proper preflight inspection of the airplane and ensure that the oil cap was secured, which resulted in a descent into terrain due to his obstructed view out of the windshield.NTSB ANC04IA058Incident · Minor injuriesIncident investigationFinal reportBoeing 757-251 · Anchorage, AKThe failure of the flight attendant to follow the appropriate door opening procedure by remaining clear of the door handle when the passenger door was opened from the outside by customer service personnel, which resulted in a wrist injury to the flight…NTSB LAX04TA264Accident · No injuriesFinal reportBell 212HP · Chester, CAthe pilot's excessive use of the cyclic and collective controls in response to the helicopter's unexpected rocking motion, which led to a main rotor contact with the upper wire cutter mounted on the cabin roof. A factor in the accident was the rough, sloping…NTSB FTW04IA147Incident · 1 fatalIncident investigationFinal reportBell 206L-1 · Smi-28Incapacitation of the pilot due to a heart attack.NTSB NYC04IA116Incident · No injuriesIncident investigationFinal reportDornier DO-328-100 · Allentown, PAThe opening of the main cabin door after takeoff, for undetermined reasons.NTSB LAX04LA197Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Van Nuys, CAthe failure of maintenance personnel to ensure the proper charge of the aft landing gear dampers in accordance with the manufacturer's recommendations.NTSB CHI04CA106Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Columbia, MOThe pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…NTSB NYC04TA103Accident · No injuriesFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)The failure of the number two upper forward right engine cowling attachment, which resulted in substantial damage to the right inboard elevator. A factor was the inadequate procedures in the airliner maintenance manual.NTSB SEA04CA068Accident · No injuriesData collectionFinal reportYakovlev Yak 54 · Friday Harbor, WAThe pilot's failure to properly align with the runway. Factors include rough/uneven terrain, inadequate preflight planning and diminished forward visibility.NTSB MIA04IA056Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Fort Lauderdale, FLThe flight crews' inadvertent setting of the parking brake during flight resulting in the airplane being landed with the parking brake set and failure of all 8 main landing gear tires during the landing rollout.NTSB SEA04IA045Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Seattle, WAThe First Officer's misidentification of the parallel taxiway as the active runway, resulting in the need for a sidestep maneuver while on short final for a full-stop landing. Factors include sun-glare from wet paved surfaces, a visual illusion created by the…NTSB ATL04LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Summerville, SCThe pilot's inadequate start procedure, which resulted in a run-away airplane.NTSB NYC04LA063Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Pittsburgh, PAThe failure of the baggage cart E-hitch pin, which resulted in the baggage cart separating from its tug, and subsequently impacting a parked airplane.NTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · 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 sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…NTSB CHI04LA053Accident · No injuriesLimited investigationFinal reportBeech E-90 · Galesburg, ILThe pilot's inadequate preflight by not complying with the airplane's before takeoff checklist to verify that the cabin door was secured leading to its in-flight separation from the airplane. A factor was that the door was not secured.NTSB LAX04FA078Accident · 6 fatalField investigationFinal reportBeech A36TC · North Las Vegas, NVAn in-flight collision with terrain for an undetermined reason while the pilot was maneuvering to return for a landing during an unknown emergency.NTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.NTSB NYC04LA042Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Jamaica, NYAn encounter with an unoccupied belt loader, after the belt loader driver inadvertently fell to the ground while maneuvering. Factors in this accident were the gusty wind conditions and the failure of the operator to require that persons operating belt…NTSB FTW04CA030Accident · Minor injuriesData collectionFinal reportBell 206L1 · Paris, ARThe pilot's failure to remove the main rotor tiedown prior to engine startup. Contributing factors were the pressure induced by conditions/events, improper preflight of the aircraft, and dark night conditions,NTSB FTW04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172N · La Grange, TXThe pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.NTSB NYC04IA010Incident · No injuriesIncident investigationFinal reportBeech 1900D · Albany, NYThe maintenance technician's improper maintenance performed on the airplane, and his failure to perform a functional check, which resulted in a restricted movement of the elevator trim wheel. Factors were the captain's inadequate preflight inspection, and…NTSB LAX04CA003Accident · Minor injuriesData collectionFinal reportBalloon Works Firefly II · Phoenix, AZthe pilot's diverted attention that resulted in the inadequate handling of the burner during ground operations.NTSB NYC03LA199Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Norfolk, VAthe airline ground person's failure to properly control the pushback tug, and her subsequent failure to maintain adequate clearance between the tug and the airplane. Factors contributing to the accident were the airline ground person's operation of the tug…NTSB MIA03LA181Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Homestead, FLthe inadequate 100-hour inspection of the helicopter by other maintenance personnel who failed to discover that the landing gear dampers had low pressure, which resulted in ground resonance and subsequent substantial damage during a run-on landing.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB NYC03FA186Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Jamaica, NYA fractured nose gear spray deflector due to contact with a tow bar during pushback, which subsequently jammed and prevented nose gear extension during landing. A factor in this accident was the tow operator's failure to detect the damaged spray deflector.NTSB NYC03CA189Accident · Serious injuriesData collectionFinal reportFairchild Dornier 328-300 · Hebron, KYThe passenger's inadvertent fall while attempting to board. A factor was the lack of a company requirement for a person to assist passengers in boarding the airplane.NTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…NTSB DEN03IA147Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe first officer's improper preflight preparation in failing to ensure the cabin airstair door was fully locked and secure. Factors relating to the incident were the cabin airstair door handle not being fully secure and the forward cabin door warning light…NTSB ANC03LA098Accident · No injuriesLimited investigationFinal reportAerospatiale SA319B · Whittier, AKThe pilot's encounter with ground resonance during landing, which resulted in an aborted landing and subsequent loss of control of the helicopter.