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 LAX89LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Benson, AZThe pilot's failure to maintain adequate airspeed during an emergency descent and to properly flare the aircraft during landing. Contributing to the accident was the pilot's anxiousness in over-reacting to a situation and prematurely entering a power-off…NTSB CHI89LA158Accident · No injuriesLimited investigationFinal reportBeech S35 · Lindon, MIThe restricted movement of the ruddervator control due to undetermined reasons.NTSB LAX89LA328Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3201 · Bullhead City, AZThe deplaning passenger's failure to observe a raised and marked area in the passenger cabin floor exit aisle. Contributing factors to the accident were: darkness and the fuselage floor exit aisle was designed with a raised area which partially obstructed its…NTSB MIA89LA206Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Ms State Univ, MSImproper in-flight planning/decison by the pilot. Contributing factors were: failure of the tow vehicle driver to use/maintain the proper speed, the pilot's lack of total flying experience, and high vegetation (uncut hay).NTSB CHI89DEM04Accident · No injuriesFinal reportCessna 175 · Lawton, MIThe pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.NTSB MIA89LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Forest, MSFailure of the pilot to maintain runway alignment and partial loss of power from water in the fuel. Contributing factors were: uneven runway, pilot's improper recovery from a bounced landing, a gusty crosswind condition, and trees.NTSB MIA89LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Atlantic Ocean (Atlantic Ocean)A gunshot wound, which resulted in a loss of the pilot's ability to effectively fly and navigate the aircraft, and a subsequent loss of engine power due to fuel exhaustion.NTSB NYC89LA156Accident · No injuriesLimited investigationFinal reportCessna 185 · Fishers, NYLoss of control during an aborted takeoff due to improper float operation aborted takeoff procedure on terra firma, as opposed to the more logical environment of water, the intended element for the design hardware.NTSB ANC89LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Kenai, AKFailure of the pilot to obtain proper assistance in starting the engine and/or his inadequate supervision. The passenger's lack of familiarity with the aircraft resulted in her improper use of the throttle which contributed to the accident.NTSB MIA89FA178Accident · 1 fatalField investigationFinal reportBeech A36 · Shelby, MSFailure of the pilot to maintain adequate airspeed while maneuvering back to the runway which resulted in an inadvertentstall. Contributing factors were: failure of the pilot to insure the cabin door (on the passenger's side) was properlyclosed and secured…NTSB SEA89LA102Accident · No injuriesLimited investigationFinal reportBeech 19A · Cashmere, WAThe pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes.NTSB MIA89LA162Accident · No injuriesLimited investigationFinal reportCessna A152 · Lake Wales, FLImproper planning/decision by the pilot by not properly securing the aircraft or obtaining proper assistance.NTSB MIA89FA154Accident · Minor injuriesField investigationFinal reportCessna 152 · Fort Pierce, FLFailure of the student pilot to maintain airspeed which resulted in an inadvertent stall. Contributing factors were: the weather conditions (smoke & haze), the student becoming lost, her lack of total experience, and her inability to understand ATC…NTSB DEN89LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Colorado Spgs, COInadequate compensation for the wind conditions by the pilot. The high density altitude and wind conditions were contributing factors.NTSB ANC89IA071Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · Anchorage, AKFailure of tires on the right inside main gear truck. A related factor was: failure of operator/management personnel to follow proper loading procedures, which resulted in an improper lateral weight and balance situation.NTSB MIA89FA137Accident · Serious injuriesField investigationFinal reportCessna 150M · Miramar, FLThe pilot's failure to continue flying the airplane when he noted a vibration of unknown origin. Contributing to the accident was the improper selection of unsuitable terrain to execute a precautionary landing when an airport and a highway median were…NTSB CHI89LA075Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Watertown, WIThe pilot's improper use of brakes and throttle. A contributing factor was the parked aircraft which was nearby.NTSB FTW89LA086Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Lampasas, TXThe pilot's failure to follow proper procedures and directives for the attempted operation. A factor was the undetermined status of the magnetos.NTSB LAX89LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 767-201 · Los Angeles, CAThe first officer did not properly evacuate the airplane.NTSB MIA89LA102Accident · Serious injuriesLimited investigationFinal reportAdams AX-9 · Jacksonville, FLThe failure of a passenger to follow pre-briefed instructions during landing.NTSB NYC89LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJImproper decision and planning by the check pilot (f/e) which resulted in loss of proper alignment and collision with a snowbank at the edge of the runway. Contributing factors were: inadequate preflight by the f/e, f/e's unsecured shoulder harness, premature…NTSB LAX89FA111Accident · 1 fatalField investigationFinal reportCessna 340A · Safford, AZThe pilot's poor judgement and the resultant hypoxia sustained in the unpressurized airplane. Factors were: the malfunctioning pressurization system and the pilot's decision to continue operation with that known discrepancy.NTSB FTW89MA047Accident · 1 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-32F · Salt Lake City, UTImproper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…NTSB NYC89LA081Accident · No injuriesLimited investigationFinal reportCessna 402B · Hyannis, MAInadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.NTSB SEA89LA038Accident · No injuriesLimited investigationFinal reportCessna 180A · Arlington, WAThe pilot attempted to hand-prop the engine without properly securing it.NTSB ATL89IA057Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Atlanta, GA1St officer was observed to be sick & was replaced on the flt prior to departing the originating city. Subsequently, he was confronted by an intervention group regarding his condition and requested medical assistance under the company employee assistance…NTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…NTSB MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…NTSB ANC89IA019Incident · No injuriesIncident investigationFinal reportCessna A185F · Deadhorse, AKAcft bounced several times during landing. The pilot collapsed shortly after getting out of the airplane. Blood samples, taken from the pilot three hours after landing, contained 22.1% carbon monoxide. The left engine muffler overboard tube was broken loose…NTSB BFO89LA010Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Dublin, WVThe pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding…NTSB MIA89IA031Incident · No injuriesIncident investigationFinal reportCessna 210L · Stuart, FLWhile hand-propping the engine with a passenger in the right front seat, the eng started. The acft travelled uncontrolled into a parked unoccupied acft. Both acft sustained substantial damage. The plt on the ground & the passenger in the acft were not…NTSB ATL89FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bridgeport, WVThe plt was cleared to execute a visual approach to rwy 21 and was issued the current alt setting of 29.60' hg. The approach was made under dark night and gusty crosswind conditions to a lighted runway in rural mountainous/hilly terrain. During final approach…NTSB NYC89LA072Accident · Serious injuriesLimited investigationFinal reportBoeing B-747-123 · Bridgetown, BahamasThe failure of the flight attendant to notice that the elevator was not present as she entered the elevator shaft and prior to closing the door.NTSB LAX89DVG01Accident · Serious injuriesFinal reportGlasair FT · Redding, CAOn takeoff, plt's canopy came open. When plt diverted attention to close canopy, acft collided with a tree, then terrain. Investigation revealed no canopy latch malfunction. Post acc exam showed that the plts canopy latches were undamaged.NTSB FTW89DPA01Accident · Minor injuriesFinal reportShannon J-BIRD · Mckinney, TXThe plt rprtd he was making a high speed taxi test of his gyroplane after installation of a different eng & prop. He said the gyroplane enctrd a bump on the rwy which caused it to become airborne at about 35 mph (takeoff speed was 45 mph). He added power to…NTSB CHI88FA249Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Columbus, OHAerodynamically stalled lifting surface causing an uncommanded pitch over at an altitude too low to affect a recovery.NTSB DEN88LA201Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Fort Morgan, COThe plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he…NTSB ANC88LA116Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Hartman River, AKThe pilot had just taken off from a sand bar. During climb-out on the downwind leg, he felt the engine was not producing the proper power because the airspeed was dropping and the climb had stopped. He made a left turn and crash landed on the sand bar to…NTSB LAX88IA311Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · San Francisco, CADuring cruise flight, approximately one hour after departure, the captain complained of possible indigestion. A few hours later, the captain complained of tingling in his fingers and numbness in his shoulder. Another captain was on board and was asked to sit…NTSB NYC88LA224Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Wall Township, NJIncapacitation of the pilot due to a heart attack and an emergency landing in trees by a non-pilot passenger.NTSB CHI88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crestwood, ILNTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.NTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.NTSB FTW88DRG11Accident · No injuriesFinal reportEnstrom F28A · Port Isabel, TXThe pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…NTSB CHI88IA165Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILNTSB MKC88LA129Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Baker, MOWitnesses said that shortly after takeoff, the fully loaded acft appeared to be unable to climb out of ground effect. About 1.5 mile from the airstrip, the pilot began a turn back to the north. Unable to climb, he initiated action to dump his chemical load,…NTSB SEA88IA121Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-73F · Seattle, WACrew noted inflight indications of loss of hydraulic fluid, then carried out standard procedures per crew manual. Emerg hyd sys used to lower flaps for lndg. Acft landed with four right brakes locked. The tires blew and the wheels were ground flat.…NTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…NTSB ANC88LA150Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Mekoryuk, AKThe pilot-in-command was herding reindeer for a native corporation and he and his passenger had to relieve themselves so they landed on the tundra and left the helicopter's engine and rotors operating. As they were exiting the helicopter, it shifted on the…NTSB BFO88IA057Incident · 1 fatalIncident investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot died from coronary disease while practicing landings.