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 LAX84IA350Incident · No injuriesIncident investigationFinal reportBoeing 747-122 · San Francisco, CAJust inside the outer marker, a 'loud bang' was heard & left aileron input was needed to control acft heading. The landing was made without incident until the flaps were raised while taxiing & the flt engineer reported a #4 hydraulic system failure. The capt…NTSB CHI84LA231Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe acft ran off a road into a ditch which destroyed the main landing gear during the forced landing. The plt said oil covered the windshield after takeoff and he could not see well enough to find the airstrip so he landed on the road while looking out the…NTSB ANC84LA089Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Talkeetna, AKThe plt had just picked up an external 'sling' load of 2700 lbs of back-fill in a cement bucket. At 900 ft AGL the acft started a vertical vibration. As collective was bottomed a large piece of one main rotor blade separated. The plt said he jettisoned the…NTSB LAX84LA349Accident · No injuriesLimited investigationFinal reportLockheed L-1011-385-3 · Los Angeles, CAShortly after the aircrew moved the gear handle from 'up' to 'off', during initial climb, they heard a loud bang in the nosewheel area. They returned to the arpt & landed after dumping fuel. An exam revealed that both lower attach lugs on the nose gear crank…NTSB LAX84IA351Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe pilots were unable to retract the right wing spoilers after takeoff, so they returned to the departure airport for an uneventful landing. An inspection revealed rust & debris in the area of the bellcrank, which prevented the #1, #4 & #5 rgt hand spoilers…NTSB CHI84FA226Accident · 1 fatalField investigationFinal reportHiller UH-12E · Merrimac, WIThe acft crashed and burned after an in-flt explosion at about 75 ft AGL as the acft approached to land. The acft had experienced electrical problems of overheating generators and irregular voltage outputs on 2 previous occasions. The pltwas told after some…NTSB ANC84LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Alexander Creek, AKThe acft experienced an oily windshield with a slight drop in oil pressure. A forced landing was made on an unimproved airstrip and the acft collided with a berm due to the restricted vision from oil on the windshield. Examination of the engine showed the…NTSB MIA84LA178Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pompano Beach, FLWhile on a local flt there was a failure of the acft's electrical charging system due to a broken alternator drive belt. The plt secured all unnecessary elect equip't & returned to the arpt. Upon entering pattern he heard tower ask if he WAS45V & if so to…NTSB MIA84IA174Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Ft.Lauderdale, FLThe acft lost eng cowling components during the landing roll. Investigation revealed that on the previous day mechanics had removed the #3 eng left & right compressor fairing & replaced the igniter plugs. The #3 eng left gas generator compressor fairing was…NTSB LAX84FA330Accident · Serious injuriesField investigationFinal reportAeronca 65-C · Corona, CAWhile taking off on a bfr flt, a pulley in the aileron control sys failed during the initial climb & the controls jammed. The CFI pushed rudder to try to counteract rolling of the acft, but the plane wallowed in the air & dove into the ground from about 40 ft…NTSB NYC84IA192Incident · No injuriesIncident investigationFinal reportBoeing 727-31 · Flushing, NYAfter takeoff flt attendant reported aft airstair partially open. Flt engineer checked & confirmed airstair open aprx 18 inches. Remedial action performed to no avail. Unscheduled landing performed without incident. As acft turned onto taxiway airstair…NTSB FTW84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bell City, LAA propeller counterweight bearing shaft failed after takeoff at max gross weight. A vibration occurred & the plt began dumping his load, but he was unable to maintain altitude. The aircraft landed in soft mud and nosed over when it collided with a rice levee…NTSB ATL84FA187Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Charlotte, NCPlt departed rwy 18L and shortly thereafter reported to the tower that he had a stuck trim. The plt was cleared to land on rwy 18R. Witnesses observed the acft descend rapidly on downwind to approx 300 to 500 ft AGL and make a steep (90 to 120 degree) right…NTSB LAX84LA314Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe helicopter experienced a tail rotor failure shortly after departing the airport on a VFR local sling loading flt. The plt stated that, 'at approx 500 ft asl on climb out experienced sudden, severe vibration. Made a 180 degree turn to return to airport &…NTSB MIA84IA172Incident · No injuriesIncident investigationFinal reportBoeing 727-35 · Bahamas, BahamasWhile climbing thru FL 240, the aircrew noted that the #1 eng fire warning light illuminated. They secured the eng in accordance with the eng fire checklist procedure, then diverted for an unscheduled landing at miami, FL. An investigation revealed that the…NTSB DEN84IA157Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Albuquerque, NMWhen gear was lowered for landing rt main gear would not extend although persons on the ground stated the gear doors appeared open. Remedial action by the flt crew did not rectify the situation and a gear up landing was performed. When acft was raised from…NTSB CHI84FA201Accident · Minor injuriesField investigationFinal reportCessna 310P · West Chicago, ILThe plt heard a loud noise during gear retraction and noted that the nose gear could not be extended. Attempts to correct the situation failed. On the approach to land he put the mixture controls in idle cut off to slow the acft. The acft stalled and landed…NTSB MKC84LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · North Platte, NEWhile in cruise flt the plt noticed a loss of electrical power. A diversion was made to North Platte, NE, where the plt hoped to have the electrical problem fixed. Numerous attempts were made to lower the landing gear but to no avail and a gear up landing…NTSB LAX84LA301Accident · Minor injuriesLimited investigationFinal reportGrumman F-6F5 · Chino, CAThe plt stated that he made a normal landing, but 'upon touching brakes, left brake appeared to lock.' He stated he was unable to correct with right rudder & brake. The acft swerved off the left side of the rwy, went into a ditch & nosed over. Witnesses…NTSB DEN84FTE01Accident · 1 fatalFinal reportHarper/Cricri MK-12 · Longmont, COThe homebuilt acft was on downwind leg of the traffic pattern, after initial takeoff, when it went into a dive & collided with the ground. A witness said he heard a power reduction before the dive & power added again as it started down. The plt's son said his…NTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…NTSB ATL84FA173Accident · Serious injuriesField investigationFinal reportBoeing 727 · Covington, KYAfter leveling at FL330, the #2 eng fire warning light & bell activated. The crew followed the published procedures, shut down the eng & used a fire bottle. They then diverted to cincinnati & made a precautionary landing. After landing, fire dept personnel…NTSB CHI84IA197Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-102 · Battle Creek, MIWhile cruising at 7000 ft MSL, the 1st officer was trimming the rudder, using the rotary switch on the center console, when he felt a 'snap' inside the switch. After that, the switch would rotate freely between the stops. The acft began yawing left & right…NTSB MIA84FA166Accident · 1 fatalField investigationFinal reportBell UH-1B · Clermont, FLThe plt was not aware that two ground attendants were riding the cable during a logging operation when there was an accidental cable release & the attendants fell to the ground. Examination of the acfts hook did not reveal a system failure or malfunction.…NTSB MIA84FA164Accident · 1 fatalField investigationFinal reportMooney M-18C · Sugar Loaf Key, FLThe acft was observed making several passes over a friends house. At the end of the third pass during, a climbing left turn, the right wing separated from the acft. Inspection of the wreckage revealed wood rot in the main wing spar. The last known inspection…NTSB LAX84LA294Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E (Soloy) · Delano, CAThe helicopter experienced an inflt failure of an eng mount, pn 63181-5, which bent the collective control rod & forced the the collective pitch into the up position. The helicopter then settled into the grapes it was spraying & made a hard landing. An…NTSB NYC84FA158Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Shirley, NYWhile climbing with a glider in tow, the tow acft pitched nose up. The glider & tow plts released the tow rope & the glider plt landed safely. The tow acft maintained a nose high attitude, stalled, then entered an uncontrolled descent & crashed. An…NTSB MKC84LA138Accident · No injuriesLimited investigationFinal reportSoneria II · Kansas City, KSThe plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…NTSB LAX84LA282Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Visalia, CAWhen the plt arrived at his destination, he was unable to fully extend the gear. He diverted to Visalia, CA. After reducing the fuel load, he made an intentional, power-off, wheels-up landing. An exam revealed that nose gear bellcrank assy had caught on the…NTSB MIA84IA160Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Miami, FLThe plt reported that during a descending turn at aprx 8000 ft & 200 KTS, the acft encountered turbulence & a lateral gust. He stated that this caused the acft to roll into about a 70 deg bank. He initiated a recovery, but the acft had gotten in a 20 deg nose…NTSB ATL84LA155Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Shaw, MSThe acft was landed gear up in a precautionary landing after a control difficulty in flt. On base leg a loud bang was heard and the acft started to roll right. Control forces were heavy so the other plt in the front seat tried to help on the controls. They…NTSB CHI84FA165Accident · No injuriesField investigationFinal reportShort Brothers SD3-30 · North Canton, OHFollowing normal lndg, plt executed 180-degree turn on runway, then taxied to gate. Normal gate arrival maneuver is a right 180-degree turn to present left side of acft to gate. As acft passed through about 135 degrees of this maneuver, hydraulic warning…NTSB SEA84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Davenport, WADuring the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured.NTSB LAX84FU026Accident · 1 fatalFinal reportTeratorn Tierra II · Chico, CAThe ultralight was being test flown after alterations to the acft & its flight control system. The plt put the acft through some maneuvers and during one of them, described by witnesses as a chandelle, the acft nosed down & crashed intothe ground. The acft…NTSB MIA84LA144Accident · No injuriesLimited investigationFinal reportCessna TR182 · Daytona Beach, FLThe plt was unable to lower the landing gear and made a wheels-up landing. An exam revealed that a rod end, pn S02321-3, on the nose gear door had failed. The failure was in tension bending with no signs of preexisting fatigue or corrosion.NTSB CHI84LA156Accident · No injuriesLimited investigationFinal reportCessna 172D · Bad Axe, MIAfter traveling 100-150 ft on the takeoff roll, the rgt brake seized & the acft veered sharply to the rgt. The acft departed the rwy & went into a muddy area where the nose gear collapsed & the acft nosed down. The plt reported that there were 200 ft long…NTSB SEA84FA090Accident · 1 fatalField investigationFinal reportBowen-Powell BP-1 · Minden, NVWitnesses observed the acft enter a right turn at about 1000 to 1500 ft AGL. The turn steepened into a tight spiral, & subsequently, the acft crashed in a steep nose down attitude. The plt was wearing a parachute & bailed out; however, the parachute became…NTSB MIA84IA147Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Ft. Lauderdale, FLAfter 2 unsuccessful attempts to 'ramp' the acft, plt took off again and flew to Ft. Lauderdale. Fly-by disclosed no nose landing wheel was present. Plt made landing on hard surface rwy. Metallurgical examination disclosed, nose gear strut assembly failed due…NTSB CHI84IA155Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Milwaukee, WIA gear up landing was performed after the crew was unable to extend the rgt main gear thru normal & emerg procedures. An exam of the acft disclosed the rgt main gear door aft hinge bolt was slightly bent & difficult to rotate in its bushing. The bushing &…NTSB CHI84FA153Accident · 1 fatalField investigationFinal reportMooney M20C · Gary, INVFR plt received 2 wx briefings, filed an IFR flt plan and departed in night IFR conditions. Aprx 1 min after contacting chicago ARTCC plt reported he was having 'problems.' Aprx 1 min later plt reported, 'nine nine victor, I'm breaking up.' Acft wreckage was…NTSB MIA84IA140Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · MartiniqueWhile climbing through FL200 crew experienced a loss of #4 hydraulic system pressure, illumination of the red 'gear door' and 'left wing door open' lights, a medium freq vibration and heard a loud rushing sound. Flt diverted to miami, FL, where landing was…NTSB FTW84FA193Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Houston, TXWitnesses heard the sound of an acft with the eng at high RPM. Shortly after that, they saw the acft in a left spin with the eng remaining at full power. The acft continued spinning until it crashed & burned. The witnesses noticed that when the plane was…NTSB NYC84LA134Accident · No injuriesLimited investigationFinal reportHughes 269A · Danbury, CTWhile in flt, the helicopter yawed & the eng RPM increased. The plt retarded the throttle to idle, lowered the collective & initiate an autorotation. While attempting to reach a suitable landing area, the plt kept his speed up to avoid buildings. However,…NTSB ATL84LA143Accident · No injuriesLimited investigationFinal reportAeronca O-58A · Rutherfordton, NCAfter the eng was started, the plt added power to taxi. He reported that the eng then went to full power & he was unable to stop the plane or control its direction thru the use of brakes & flt controls. The plane struck 3 other parked acft before the plt…NTSB DEN84LA124Accident · No injuriesLimited investigationFinal reportBell 206B · Farmington, NMWhile climbing, there was a heavy smell of fuel. At aprx 150 ft AGL on a precautionary landing, the eng quit. The helicopter impacted hard, collapsing the skids, & the main rotor blades sheared of the tail boom. During an investigation, the fuel hose b-nut…NTSB LAX84LA242Accident · No injuriesLimited investigationFinal reportCessna 210 · Tucson, AZThe acft had a hydraulic line failure during an attempt to lower the landing gear. The hydraulic fluid was lost and a gear up landing was made. The retaining ring of the main door actuator had failed allowing the piston to pop out of the actuator. There was a…NTSB NYC84LA124Accident · No injuriesLimited investigationFinal reportBeech B19 · Simsbury, CTDuring an instructional flt, a landing was made during which control of the acft was lost and the acft collided with a snow bank hard enough to shear off one of the main landing gear. The other main gear collapsed but the nose gear did not. The instructor…NTSB MKC84LA113Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Osage City, KSDuring an aborted takeoff, executed due to an inoperative airspeed indicator, the acft swerved off the left side of the rwy across a ditch, damaging the left wing & main landing gear. A clogged pilot tube was the cause of the airspeed indication of zero mph.…NTSB FTW84LA184Accident · No injuriesLimited investigationFinal reportCessna 402B · El Paso, TXDuring gear extension in preparation for landing the nose gear failed to extend fully even though emergency gear extension proceedures were performed. The plt steered the acft off to the right of the rwy shortly after touchdown. Acftinspection revealed a…NTSB ATL84IA134Incident · No injuriesIncident investigationFinal reportBeech C90 · Herndon, VAThe acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…