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 CHI86LA032Accident · Minor injuriesLimited investigationFinal reportRockwell 112 · Pekin, ILFollowing a top overhaul of the engine a test flight was planned to break in the cylinders and rings. Prior to this flight the engine was operated for a short period on the ground then shut down and checked for oil leaks with negative results. The takeoff and…NTSB MIA86LA030Accident · No injuriesLimited investigationFinal reportCessna 210M · Ft.Lauderdale, FLWhile in cruise flight the pilot attempted to lower the landing gear and the right main landing gear would not extend. During this process the aircraft generator went off the line. The pilot attempted to manually lower the landing gear and extended the nose…NTSB DEN86LA025Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 6B · Englewood, COThe plt stated that while on a Balloon flt, the blast valve, which operates the burner flame, stuck open during one of the burns. The plt attempted unsuccessfully to disengage the blast valve. When the plt could not stop the flame with the blast valve, he…NTSB LAX86LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Springerville, AZThe plt stated that the eng oil pressure dropped to zero while the acft was in cruise flight. He selected an open field in which to make a precautionary landing. He said that as he approached the field the acft entered a downdraft. He stated he had reduced…NTSB DEN86FA023Accident · Serious injuriesField investigationFinal reportBeech A45 · Albuquerque, NMWhile maneuvering to enter traffic at alameda arpt, the plt experienced severe acft vibrations. He attempted but was not able to reach the arpt due to rapid loss of airspeed andaltitude. The acft crashed 1/2 mile from the landing rwy. The one pax and a…NTSB ATL86FMG04Accident · No injuriesFinal reportCessna 177RG · Kenansville, NCThe acft contacted two piles of dirt during a gear-up landing. The plt took off with intensions of practicing touch and go landings. On the second apch, the plt was unable to fully extend the landing gear. The plt had one passenger check the hydraulic fluid…NTSB NYC86LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · New York, NYAccording to the pilot, the purpose of the flight was to provide the student with night flying instruction. The preflight and run up revelaed no discrepancies and 10 quarts of oil were determined to be in the engine. The aircraft proceeded south along the…NTSB FTW86FA023Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, LAThe instrument flight instructor and student experienced a directional gyro failure. They covered the instrument and requested a return to their departure point. The aircraft was not equipped to fly the published approach. They requested a descent to an…NTSB CHI86LA022Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kenosha, WIAccording to the pilot the flight from toledo to the kenoshaarea was uneventful. During the VOR approach to rwy 14 (approx 2 miles from the end of the runway) the aircraft impacted the ground and was destroyed. The pilot stated that the last thing he rembered…NTSB DEN86LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe plt stated he had just departed a site located on top of a mountain, which is approximately 12,200 ft MSL. The pilot said 30 seconds later, the helicopter lost partial power. Requiring him to make a force landing. The inspection of the turbocharger…NTSB CHI86LA021Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bangor, MIThe acft nosed over after landing on a grass landing strip. The pilot stated the tail came up and the aircraft flipped over on its back after left brake was applied. An examination of the landing gear and brakes revealed that the right brake was released but…NTSB MKC86IA018Incident · No injuriesIncident investigationFinal reportSAAB-Fairchild SF340A · Lincoln, NEDuring landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on…NTSB ATL86MA011Accident · 2 fatalMajor investigationFinal reportBeech 58P · Forsyth, GAThe flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to…NTSB NYC86LA020Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Lee Center, NYThe acft experienced a loss of control during an apch to the plt's pvt airstrip. After a pleasure flt of one-half hour, with no reported problems the acft returned to the arpt. On about a one-half mile final, the acft entered a steep left turn at about a 60…NTSB FTW86LPA01Accident · No injuriesFinal reportCessna 150M · Arlington, TXThe acft nosed over over in a fld during a forced landing. The plt reported that the cockpit began filling with smoke shortly after takeoff. Shortly thereafter the eng quit. The acft traveled aprx 700 ft during the landing roll before the nose gear dug into…NTSB LAX86LA023Accident · No injuriesLimited investigationFinal reportPiper J3 · Green Valley, AZOn oct 24, 1985, a Piper J3 cub,N33461, made an emergency landing in rough, open terrain near Green Valley, AZ. After experiencing a loss of engine power the ac sustained substantial damage and the pvt plt was not injured. The investigation revealed that the…NTSB ATL86FLQ03Accident · Minor injuriesFinal reportPiper PA-28RT-201T · Hopkinsvile, KYThe acft had electrical failure during an IFR flt and radio/radar contact was lost. The plt said he was in & out of the clouds during the final stages or the x-country flt. The cloud ceiling was about 800 ft where he finally descended & landed in a soybean…NTSB BFO86LA004Accident · No injuriesLimited investigationFinal reportStinson 108-1 Voyager · The Plains, VAWhile flying straight and level at 3100 feet MSL, over Virginia route 66 and route 245, the engine began to vibrate to the extent that the plt thought that it might separate from the airframe. The plt selected a field and set up an approach. On final, the plt…NTSB FTW86FA016Accident · No injuriesField investigationFinal reportBell 222A · Charenton, LAThe helicopter had just completed a phase two check, twenty minutes into the flight the occupants heard a loud noise and a severe one-to-one vibration ensued. A successful emergency landing was performed. Examination revealed that one swash plate drive link…NTSB MKC86LA006Accident · No injuriesLimited investigationFinal reportBeech A36 · Chesterfield, MOThe pilot was on an IFR flight plan flight when the engine alternator failed and the aircraft battery became so depleted that the nav and com equipment failed. Pilot was able to descend to VFR conditions. He stated he used the checklist to manually extend the…NTSB MIA86LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLThe plt experienced nose wheel shimmy during the landing roll. He then applied back pressure and the acft ballooned back into the air. The acft landed on the nose wheel damaging the prop & nose gear.NTSB FTW86LA006Accident · No injuriesLimited investigationFinal reportFairchild F-27 · Houston, TXAcft veered left off the runway shortly after touchdown, collapsing the nose gear. Winds at the time would have resulted in direct crosswind of 9 kns. The crew that was contracted to ferry the acft noted, when they picked it up, that there were several open…NTSB MIA86LA006Accident · No injuriesLimited investigationFinal reportNorth American Navion · Tallahassee, FLThe plt stated that while doing touch-and-go landings at quincy, FL, the left main strut fell off the acft. He then returned to Tallahassee and made an intentional gear-up landing. Examination of the main landing gear scissor ass'y revealed that it failed due…NTSB MIA86IA001Incident · No injuriesIncident investigationFinal reportPiper PA-32-300 · Jacksonville, FLAfter departure flight experienced loss of engine power and visible smoke coming from the windshield exhaust ducts. The engine subsequently failed but the pilot was able to regain power and return to the airport for a normal landing. Post landing inspection…NTSB DEN85IA250Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, CODuring gear extn for lndg, the flt crew noted a 'loud & very noticeable jolting of the acft.' Shortly thereafter, they also noticed that a portion of the right main gear had punctured the upper surface of the rgt wing. The crew then declared an emergency &…NTSB SEA85FA228Accident · 2 fatalField investigationFinal reportTeratorn Tierra II · Post Falls, IDThe acft contacted the terrain in an uncontrolled descent following an inflt separation of the left wing. A witness stated the left wing separated as the acft was being maneuvered in a race track pattern using bank angles of 45 degs. The wife of the acft…NTSB MIA85LA262Accident · No injuriesLimited investigationFinal reportCessna 172N · Hollywood, FLThe plt stated that shortly after takeoff from ft. lauderdale, he felt a severe vibration and shut down the eng and made a emerg landing in an open field. Post crash investigation revealed that one propeller blade separated aprx one foot from the hub.…NTSB LAX85LA400Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Watsonville, CADuring an ag flt, at abt 5 ft AGL, the plt heard a loud bang, the eng oversped, & all pwr to the rotor blades was lost. The plt attempted to immediately land in the underlying field, but had insufficient altitude/airspeed to autorotate. The acft touched down,…NTSB LAX85LA397Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe plt stated that the afct's throttle stuck in the full power position. He shut the engine down using the mixture control, but misjudged his altitude, stalled the aircraft & crashed short of the runway. The condition of the wreckage precluded determination…NTSB DEN85LA244Accident · No injuriesLimited investigationFinal reportCessna 425 · Boulder, COThe plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a…NTSB SEA85FA217Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Orchards, WAThe pvt plt was observed executing a wings level pull-up from a dive during which, the witness reported, the wing tips began fluttering. Immediately thereafter, both wings separated in positive overload. Visual meteorological conditions existed in the area of…NTSB CHI85FER02Accident · No injuriesFinal reportGrumman 164A · Becker, MNThe plt reported the eng pwr dropped from 2000 to 1550 RPM during the aerial application flt. The plt increased throttleand advanced the prop with no increase in pwr. The acft then settled to ground impact and nosed over. Post accident inspection disclosed…NTSB ANC85LA177Accident · No injuriesLimited investigationFinal reportCessna A185F · Cordova, AKThe plt stated that prior to landing, the acft's right brake had no pressure. He reported that after he landed, the tail wheel began to shimmy & the acft pulled to the left. He applied full right rudder, but was unable to prevent the acft from ground looping…NTSB ATL85MA275Accident · 6 fatalMajor investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Eva, ALDrg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd . . .' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…NTSB NYC85LA234Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · East Swanzey, NHThe acft was preflighted & determined to have 10 qts of oil in the eng. While climbing thru about 1000 ft MSL after takeoff, the propeller RPM began rising to the redline. The plt reduced power & proceeded to make an emerg landing. During a turn toward the…NTSB LAX85IA396Incident · No injuriesIncident investigationFinal reportNorth American SNJ-4 · Reno, NVThe pilot experienced a 'severe vibration' and made an emergency landing during a heat race at the national championship air races. Subsequent examination revealed that a propeller blade pitch change bolt, p/n 53546, had failed, allowing one propeller blade…NTSB CHI85IA369Incident · No injuriesIncident investigationFinal reportFokker F27-500 · Chicago, ILAt about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &…NTSB CHI85FEM02Accident · Minor injuriesFinal reportCessna 170A · Fruitport, MIThe acft was destroyed during a precautionary landing after the left side of the eng cowling opened shortly after takeoff. The plt reported the cowling opened at an alt of aprx 50 ft AGL. A climb to 300 ft was made and the acft was turned onto downwind. The…NTSB ATL85LA268Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Florence, SCThe plt was unable to extend the landing gear & performed a gear-up landing. Post accident examination revealed that the nose gear door was restricting the movement of the landing gear due to improper repair of the landing gear door attachment.NTSB MKC85LA201Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Weskan, KSThe plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any…NTSB NYC85LA256Accident · No injuriesLimited investigationFinal reportSwearingen 226T · Hamilton, NYThe aircraft was on approach for landing at Hamilton, new york when the cross power levers were pulled back to flight idle. The left prop went into beta mode stalling the left wing at about 8 feet above the runway. The aircraft rolled about 20 degrees to the…NTSB MIA85IA242Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar PA-600 · Sarasota, FLWhile on takeoff initial climb the right engine hydraulic pump shaft failed and the pilot did not receive a positive uplock. The pilot then selected gear down and did obtain a gear down indication. On landing the nose gear collapsed. Nose gear down locks were…NTSB CHI85LA363Accident · No injuriesLimited investigationFinal reportCallair A-9 · Hollandale, MNDuring a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft…NTSB MIA85LA240Accident · No injuriesLimited investigationFinal reportCessna 310B · Hawthorne, FLWhile on a x-country flt the plt stated that the autoplt was erratic, hot and smoking. The plt further stated that he continued to use the autoplt. At about 1000 ft on final apch the autoplt failed for unknown reasons and the acft nosed down. The acft crashed…NTSB NYC85LA226Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Wrightstown, NJDuring an enroute climb the pilot noticed a manifold pressure loss on the left engine. Oil pressure and temp gauges went off and the left engine was secured by the piilot. During shutdown a passenger informed the pilot that the left wing was turning brown.…NTSB LAX85FA373Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC Metro II · Fresno, CAWhile in cruise flight at 16,000 feet one of the three propeller blades separated at the shank. The unbalanced condition twisted the eng from its mounts and into the fuselage. The cabin was punctured and rapid decompression followed. The crew was able to…NTSB LAX85FJA06Accident · 1 fatalFinal reportEmroth Emair MA-1B · Pahala, HIWitnesses reported seeing pieces of wood and fabric coming off the acft during it's second swath run. At the end of the run, the acft climbed abruptly to clear trees after which it entered an uncontrolled descent to ground impact. The acft was destroyed by…NTSB LAX85IA370Incident · No injuriesIncident investigationFinal reportBeech B19 · Van Nuys, CAAfter departure, at about 800 feet, the right airleron became disconnected. The pilot was able to make a left turn, fly a left hand traffic pattern and land successfully. Examination of the aircraft revealed that the right inboard aileron control push rod had…NTSB LAX85LA353Accident · No injuriesLimited investigationFinal reportMike Stone Moni · Byron, CAWhile on the initial test flt, the amatuer-built r. m. stone moni acft crashed near Byron, CA. The plt reported that during the flight the acft began to 'flutter', followed by separation of the canopy. Shortly thereafter the acft entered into an…NTSB MKC85FA189Accident · Serious injuriesField investigationFinal reportBell 47G-2A · Sedalia, MOThe plt was taking 2 passengers on a helicopter ride at a fair. Immediately after lift-off, he encountered a situation where he was unable to maintain directional control, so he reduced power & landed. Before coming to rest, the tail of the helicopter struck…