NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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\" = 130) 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" = 130) 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 DEN84FA115Accident · Serious injuriesField investigationFinal reportCessna 172RG · Greeley, COThe acft collided with trees and the ground during a night forced landing. The acft had made some strange sounds and started vibrating after takeoff. A glide was set up for a forced landing. Since the arpt could not be reached a landing was made on a dry…NTSB ATL84FMG03Accident · Minor injuriesFinal reportBowers FLY Baby 1A · New Bern, NCThe plt stated the acft lost lateral control during takeoff. He reduced power and landed the acft off the side of the rwy while maintaining directional control using the rudder. The acft stalled at about 20 ft AGL and was damaged during the hard landing.…NTSB MKC84LA109Accident · No injuriesLimited investigationFinal reportCessna 188B · Lake Village, ARAs the acft began to rotate during takeoff one propeller blade was thrown 1000 ft behind the acft. The remaining blade and hub became unbalanced, twisting the engine at a 45 degree angle. Plt shut down the engine. Acft traveled off the left side of the rwy…NTSB LAX84LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Tucson, AZShortly after passing watson intersection inbound to tuscon, AZ the outboard tip of one propeller blade separated. The plt turned the magneto switch off and slowed the acft until the propeller stopped rotating. He then executed an emergency landing short of…NTSB ATL84FKG07Accident · No injuriesFinal reportCessna 172P · Atlanta, GAThe plt was having trouble with his radios, electrical system, fuel/eng gages & ammeter, so he turned off his electrical equipment & prepared to make an emergency landing. Because he was afraid of fuel exhaustion, his spacing behind another acft in the…NTSB MKC84LA105Accident · No injuriesLimited investigationFinal reportBeech A36TC · North Platte, NEThe acft had just departed North Platte airport and retracted the landing gear. The acft door then opened, the pilot elected to land back on the runway and failed to remember to lower the landing gear.NTSB MKC84LA102Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Ulysses, KSThe plt made an autorotative precautionary landing after feeling vibrations in the anti-torque pedals. The acft was turned into the wind but landed hard in a field. The plt upon exiting the acft found the anti-torque rotor and gearbox missing. They were found…NTSB MIA84FA106Accident · Serious injuriesField investigationFinal reportSouthern Comfort · Lakeland, FLWhile performing aerobatics at an airshow, the fabric on top of the upper wing started separating from the wing. The plt continued flying the acft & tried to return to the arpt. However, when flt could not be maintained with full power, due to loss of…NTSB MKC84LA101Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Biscoe, ARAfter spraying operations acft propeller would be pressure sprayed. Water entered propeller pitch change bearings which corroded bearings. Eventually pitch movement was hindered by rust corrosion. The blade counterweight bolt broke allowing the propeller…NTSB FTW84IA160Incident · No injuriesIncident investigationFinal reportBoeing 727-23 · Dfw Airport, TXThe crew stated that while at FL370, the cabin alt began to climb. An emergency descent was initiated & after landing the passengers deplaned in a normal manner. Investigation revealed a 9X18' hole in the fuselage about 3 ft foward of the acft cargo door.…NTSB MKC84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Olathe, KSAt FL240, a fire broke out in the rgt eng compartment. The plt indicated that the eng turbo-charger was malfunctioning. The plt shut down the eng & asked for radar vectors to johnson county executive arpt. The fire went out at 21,000 ft & the acft landed…NTSB FTW84IA163Incident · No injuriesIncident investigationFinal reportBeech BE-200 · Fort Worth, TXAcft veered rt on touchdown. Heavy braking and differential pwr used to maintain directional control. Both rt side tires and the left outboard tire blew during rollout. Plt stated left main gear unsafe light illuminated during rollout. After engines were…NTSB FTW84FU005Accident · Serious injuriesFinal reportEipper Quicksilver MXL · Huntington, TXThe plt made several touch and go landings in his newly acquired ultra light vehicle. On a subsquent flt at about 75 ft AGL, the outboard portion of the left wing folded upward about 90 degrees. The vehicle started to roll inverted and the plt used full…NTSB ANC84LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Iliamna, AKThe acft cowling came unfastened during cruise and the plt elected to make a precautionary landing. During the landing, the plt lost directional control and collided with a snowbank.NTSB MIA84FA095Accident · Serious injuriesField investigationFinal reportMonnett Moni · Indiantown, FLThe acft crashed in pieces after the airframe failed while the plt was performing aerobatics. The plt used his parachutewhile still belted to the tail section of the acft which was lowered by the chute. The wreckage consisted or six main pieces of separated…NTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…NTSB MIA84FA091Accident · Serious injuriesField investigationFinal reportCessna 185F · Key West, FLThe acft landed after a previous flt & was refueled & preflight for another mission. According to maintenance personnel, the acft floats were drained once every morning before the 1st flt of the day in accordance with the manufacturer's recommendations. The…NTSB CHI84IA114Incident · No injuriesIncident investigationFinal reportBeech 99 · Champaign, ILThe plt reported that during arrival to the destination arpt, he heard a loud bang & the acft began rolling to the right. He reported that he was unable to control the roll with the ailerons, so he reduced power on the left eng & applied left rudder. The crew…NTSB FTW84LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G4A · Refugio, TXThe helicopter was being used to herd cattle in a heavily wooded/brushy area. The plt reported he was in a hover maneuver at 50-60 ft AGL when he heard a loud sound from the rear of the helicopter. It immediately pitched nose down & started to rotate to the…NTSB FTW84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bastrop, TXThe engine lost power and the plt noticed smoke coming from the defrost vent. An emergency landing was made on a local highway. Examination revealed that the exhaust pipe was disconnected from the muffler and the hot gases melted a rocker box oil drain line.…NTSB MKC84LA093Accident · No injuriesLimited investigationFinal reportCessna 206 · Pine Bluff, ARThe acft ran off the rwy and into a ditch during landing. After the accident it was found that the nose wheel steering needed rebushing and the nosewheel damper was also in need of repair for safe operation of the acft.NTSB LAX84LA184Accident · No injuriesLimited investigationFinal reportBeech M35 · Santa Ana, CAThe plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…NTSB FTW84IA135Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Tulsa, OKThe acft experienced a nose wheel steering malfunction & ran off the rwy during landing. The nose wheel system was removed from the acft & submitted for inspection & overhaul. Examination revealed that the lever shaft 'ears' had separated from fatigue.NTSB FTW84LA136Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58E · Morgan City, LAThe helicopter was hovering above trees at about 100 ft AGL when the tail rotor chip detector lgt flickered svrl times, then illuminated steadily. This was followed by a loud grinding noise from the tail area & the acft yawed to the right. The acft entered an…NTSB NYC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Hastings, NYThe acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…NTSB MKC84LA072Accident · No injuriesLimited investigationFinal reportCessna 150H · Conway Springs, KSWhen the oil access cover opened in flt, the plt made a precautionary landing on a road. During the landing roll the pltlooked down to push in the carburetor heat control and the right wing hit a pole. The acft nosed over.NTSB MIA84IA074Incident · No injuriesIncident investigationFinal reportBeech 95-A55 · Opa Locka, FLThe acft was intentionally landed with the landing gear retracted when the lt main gear could not be extended. Inspection of the acft revealed that the spring which pulls the lt main gear uplock out of the way when released had become disconnected from the…NTSB MIA84IA077Incident · No injuriesIncident investigationFinal reportGrumman G-73 · West Palm Beach, FLThe acft experienced an elevator trim loss, encountered extreme 'shaking and vibration' of control column and tail section fluttering while on descent to Palm Beach int'l arpt. Investigation revealed that the end of the actuator shaft failed at a rivet hole…NTSB LAX84LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Lake Havasu Cit, AZIn cruise at 8,500 ft MSL the propeller ass'y forward of the mounting flange separated from the acft. During the forced landing rollout the acft struck a tree. Airworthiness directive 82-27-01 called for inspection of the prop hub and mounting bolt hole areas…NTSB ATL84FA092Accident · 1 fatalField investigationFinal reportCessna 210 · Newport News, VAThe flight had been airborne for aprx 38 mins when the pilot began experiencing communication problems. Nine minutes later the pilot reported 'instrument problems' and began to receive radar vectors to a landing. 15 minutes later she declared an emergency and…NTSB MIA84FA072Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Hoboken, GAWhile on base leg for landing, the forward right wing strut failed causing the right wing to separate. The acft then entered an uncontrolled descent & crashed. The non-certificated plt owned the acft. He had not complied with airworthiness directive 77-03-08.…NTSB DEN84LA080Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe plt noticed the throttle sticking on takeoff and tried to abort the takeoff but the throttle was binding. The acft tookoff at a below normal speed and had to be landed. Subsequently, the acft impacted the ground & several trees. An engineer said the…NTSB LAX84LA161Accident · No injuriesLimited investigationFinal reportCessna 401A · San Francisco, CAThe acft was landed gear up after attempts to lower the gear were unsuccessful. The system malfunctioned because the nose gear jammed the main gear during retraction. The jamming occurred because the nose strut did not extend due to lackof air pressure. The…NTSB DEN84LA074Accident · No injuriesLimited investigationFinal reportCessna 210D · Englewood, COThe acft was landed with the main gear retracted after attempts to extend them failed. After landing the acft departed the right side of the rwy. Post accident examination revealed that the secondary relief valve had failed in the hydraulic power pack. This…NTSB MIA84LA065Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft.Myers, FLThe acft was rolling on the rwy after a smooth landing when the left tire blew out and the left landing gear collapsed. The acft swerved to the left into the wind and slid off the left side of the rwy. According to the plt, the wind was from 090 deg at 18…NTSB MIA84IA063Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Tampa, FLThe acft experienced a rapid loss of fuel quanity on the #1 fuel tank during the climb to cruise. Investigation revealed that prior to this flt the water separator access door had been replaced by a fabricated metal plate which separated in flt. The separated…NTSB CHI84LA090Accident · No injuriesLimited investigationFinal reportCessna 210D · Rockford, ILThe plt was on a maintenance test flt to check the landing gear hydraulic power pac. He was unable to lower the main landing gear and landed with the nosewheel down. Examination of the hydraulic pac after the accident revealed that the hydraulic system had…NTSB FTW84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Albuquerque, NMThe pilot made an emergency landing after a total power loss. Prior to the total loss there had been approximately four drops in manifold pressure. The gear collapsed on landing, bending the engine mounts & both wing spars. The subsequent investigation…NTSB FTW84LA111Accident · No injuriesLimited investigationFinal reportCessna T210N · Waring, TXDuring flt in IMC conditions, the alternator became inoperative. Subsequently, the acft lost electrical power, but the plt had gotten into VMC conditions. He elected to land on a private grass strip. He reported that his apch speed was too fast, he landed…NTSB ATL84FU003Accident · 1 fatalFinal reportPterodactyl Ascender II · Lawrenceville, GAThe plt took off in conditions of turbulence & gusty winds. Witnesses reported the ultralight vehicle pitched & rolled erratically after lift-off. The plt then made a right climbing turn to a downwind heading & proceeded over a tall tree line toward a field…NTSB CHI84LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Waverly, OHWhile landing on a 2000 ft rwy at Waverly, OH, the brakes were not effective, so the plt elected to go-around. During the go-around, the acft hit a fence at the end of the rwy. The plt continued flt to the ross county arpt & landed. An exam of the brakes…NTSB NYC84IA066Incident · No injuriesIncident investigationFinal reportLockheed 1329-25 · Teterboro, NJN322CS landed with the left main landing gear partially extended after emergency gear extention procedures failed. Investigation revealed the left actuator cover door & strut cover doors jammed where the two pass in close proximity during the gear extention…NTSB LAX84FA125Accident · 1 fatalField investigationFinal reportStriplin SKY Ranger · Lancaster, CAThe plt was participating in certification tests of the acft. Witnesses stated that the plt had made a pass down the rwy & was on the downwind leg of the traffic pattern, at abuot 100 ft AGL, when the acft suddenly pitched down & crashed. An exam of the…NTSB CHI84LA069Accident · No injuriesLimited investigationFinal reportCessna U206F · Eveleth, MNThe plt reported that after taking off, the cabin began to fill with smoke. He returned to the arpt for a precautionary landing; however, during touchdown, the left wing collided with a snowbank beside the rwy. An exam of the acft revealed that with the eng…NTSB LAX84FU024Accident · 1 fatalFinal reportEipper MX · Ramona, CAThe plt was flying the ultralight vehicle to check it out before allowing his student to solo. Aprx 15 min after the plt took off, he was flying over the arpt at about 400 ft AGL when witnesses heard a 'loud non-metallic' sound from the vehicle. At about that…NTSB NYC84FA061Accident · Serious injuriesField investigationFinal reportAerospatiale SA-360C · Newark, NJThe helicopter arrived at the Newark intl arpt at 1531 after an uneventful flt from new york, NY with 2 en route stops. At 1540, the plt taxied from the passenger gate for departure. According to him, he had no control problems, while taxiing. He checked the…NTSB ATL84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Edgewater, MDA student plt started to fly the acft, but as she was moving on the rwy, she detected a misfiring of the eng that she reported as a popping sound. Therefore, she returned to the ramp area & shut down the eng. Her husband agreed to fly with her around the…NTSB LAX84LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Rosa Island, CAAccording to the plt, the nose of the acft felt heavy just before lift-off & when he became airborne. He felt something was wrong with the tail of the acft & that he was unable to obtain full elevator response, so he aborted the takeoff. The acft rolled 300…NTSB MKC84LA041Accident · No injuriesLimited investigationFinal reportCessna 310 · Olathe, KSThe plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the…NTSB ATL84FA068Accident · 1 fatalField investigationFinal reportCessna C-172M · Chesapeake, VAThe acrt crashed into a lake while making a low pass when the plt was distracted by a passenger door that would not stay latched. The acft collided while turning and the plt stated that he was trying to help the passenger close the door. He also stated that…