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 LAX97IA243Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Ontario, CAa laser light source of undetermined origin directed toward the cockpit window of an aircraft in-flight by a person or persons unknown.NTSB CHI97IA212Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Memphis, TNthe spoiler cable was misrouted by unknown maintenance personnel.NTSB LAX97LA230Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Beaumont, CAthe pilot's inadvertent movement of the propeller controls, instead of the throttle levers, which resulted in an inadvertent dual engine shutdown. Factors relating to the accident were: the pilot's failure to properly secure the door during preflight, and his…NTSB IAD97LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Block Island, RIThe pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.NTSB ANC97LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Prudhoe Bay, AKThe pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.NTSB ATL97LA086Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MDHC-369E · Okahumpka, FLThe failure of the crewmember to use the necessary safety equipment, and his subsequent fall from an elevated platform. A factor was the crewmember's distraction with an animal.NTSB LAX97LA204Accident · No injuriesLimited investigationFinal reportBell 204-B · Kaneohe, HIfailure of the pilot to verify that the load was properly rigged before attempting to pick it up. The uneven (sloping) terrain was a related factor.NTSB IAD97LA082Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Poughkeepsie, NYThe pilot's delayed decision to abort the landing.NTSB ATL97LA075Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-3 · Atlantic Ocean (Atlantic Ocean)The failure of the flight attendants to maintain control of loose cabin service equipment, a salt shaker, that resulted in an uncorrected tripping hazard.NTSB FTW97LA201Accident · No injuriesLimited investigationFinal reportCentrair 101C · Santa Fe, NMthe pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.NTSB NYC97LA095Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe vehicle's driver failure to maintain adequate clearance from and resulted in a collision with a parked aircraft.NTSB NYC97LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Pottstown, PAwas the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.NTSB FTW97IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Corpus Christi, TXThe flightcrew's inadequate in-flight planning and decision, and their failure to refer to the navaids needed for the instrument approach procedure. A factor was the lack of a minimum safe altitude warning from approach control.NTSB FTW97LA177Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Denver, COThe flight attendant's failure to assure that the jetway was placed in the proper position prior to opening the forward cabin entry door.NTSB ANC97LA075Accident · No injuriesLimited investigationFinal reportCessna 207A · Minto, AKThe pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.NTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.NTSB LAX97IA161Incident · Minor injuriesIncident investigationFinal reportBoeing 737-500 · Rialto, CAa laser light source of undetermined origin, directed by unknown person(s) toward the cockpit window of the aircraft, while the aircraft was on an approach to land.NTSB LAX97LA157Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Hilo, HIthe pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.NTSB MIA97LA125Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC10-30F · Memphis, TNA stall buffet or a high speed buffet event which occurred at an undetermined time.NTSB LAX97FA149Accident · No injuriesField investigationFinal reportAerospatiale AS350D · Los Angeles, CAthe pilot's failure to ensure that the collective lock was properly seated before deplaning.NTSB SEA97LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Portland, ORthe flightcrew's inadequate preflight, and the ramp agent's inadequate dispatch of the aircraft. The unsecured cargo door was a factor.NTSB NYC97LA064Accident · 1 fatalLimited investigationFinal reportLockheed L-1011 · Jamaica, NYThe failure of the right wing walker, also the push back supervisor, to identify and avoid a hazardous condition, which resulted in his activity near the airplane's nose wheel during tow operations, and where he was subsequently caught under the nose wheel. A…NTSB LAX97LA133Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Sacaton, AZthe pilot's improper use of the collective by not maintaining rotor rpm during takeoff from a confined area.NTSB FTW97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hartsel, COThe pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…NTSB ATL97IA042Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Atlanta, GAfailure of ground service personnel to properly close the aft cargo door before the airplane departed.NTSB NYC97LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-44-180T · Caldwell, NJThe pilot's incapacitation due to a heart attack.NTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.NTSB FTW97IA084Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Oklahoma City, OKexistence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.NTSB LAX97LA073Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-15 · Las Vegas, NVthe ramp agent's failure to maintain a good situational awareness of the push-back. A factor was the dark night lighting conditions and the general communication failure of the ground push-back crew.NTSB LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB CHI97IA033Incident · No injuriesIncident investigationFinal reportBoeing 767-300ER-33A · Chicago, ILthe approach controller's failure to issue the frequency change to the flightcrew, and the pilot landing without clearance. A factor relating to this incident is the pilot's decision to land without clearance.NTSB FTW97LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Alamosa, COaircraft damage for undetermined rteasons.NTSB LAX97LA034Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Flagstaff, AZAn uncommanded main rotor blade to tail boom contact due to a 'blowback' phenomena after a successful preplanned autorotation by the pilot to a high density altitude airport with a test aircraft designed at a maximum gross weight.NTSB FTW97LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Watkins, COThe flight instructor's improper decision to attempt a hovering autorotation during gusty wind conditions. A factor was the gusty wind.NTSB LAX97LA016Accident · No injuriesLimited investigationFinal reportWaco QCF · Big Bear City, CAthe pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.NTSB IAD97LA004Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Krosno KR-03A · Kutztown, PAthe glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…NTSB FTW97LA022Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 90 · Albuquerque, NMThe passenger's failure to follow instructions for disembarking.NTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.NTSB FTW97LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Colorado Spgs, COthe student pilot attempting to exit the runway onto a taxiway at excessive speed. A factor was the pilot's failure to land the aircraft in the proper touchdown zone.NTSB FTW97IA003Incident · No injuriesIncident investigationFinal reportBeech 1900D · Pueblo, COPartial incapacitation of the flightcrew for unknown reasons.NTSB NYC97LA084Accident · No injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-S · Wadsworth, OHThe pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…NTSB FTW96LA394Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF-340B · Fort Smith, ARthe passenger fell for undetermined reasons, while disembarking from the airplane.NTSB FTW96LA355Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Clinton, LAthe instructor pilot's failure to follow recommended procedures to properly brace himself in preparation for landing.NTSB ANC96LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Dillingham, AKThe pilot's failure to maintain an adequate visual lookout in order to see and avoid all ground personnel, his failure to follow company procedures and directives regarding Public Protection, and his disregard of the unsafe/hazardous conditions created by…NTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…NTSB LAX96LA277Accident · No injuriesLimited investigationFinal reportRobinson R22B · Morgan Hill, CAThe student's improper reaction to an engine/main rotor overspeed condition, and his failure to achieve the proper zero airspeed nose high attitude during a touchdown from an autorotation.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB NYC96LA150Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Providence, RIthe passenger inadvertently lost his balance and fell, while deplaning.NTSB CHI96LA206Accident · Serious injuriesLimited investigationFinal reportMitchell T Champabria · Kalamazoo, MIthe pilot's improper positioning of the throttle, while hand propping the aircraft engine, and his failure to either obtain proper assistance or properly secure the airplane.NTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.