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 DEN89IA028Incident · No injuriesIncident investigationFinal reportBeech S-35 · Matheson, COThe private plt and a friend were enroute for a hunting trip. Thirty miles east of a refueling stop, the pilot heard a loud knock. Oil covered the windscreen and the engine seized. The plt looked out the side window vent to select a forced landing area. A…NTSB BFO89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dover, DEAfter takeoff the plt began a cruise climb to 5500 ft. he rprtd that when the acft reached 5200 ft, he noticed oil spraying from underneath the front of the eng cowling. The oil eventually covered the windscreen. The plt diverted toward a nearby arpt, but the…NTSB MIA89LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, MSDuring normal cruise flt a portion of one propeller blade separated. The plt landed the acft in a field & during the landing roll, the acft collided with a haystack. Examination of the propeller blade revealed it separated at blade station 28.5. Metallurgical…NTSB FTW89LA010Accident · No injuriesLimited investigationFinal reportHughes 269C · Dickens, TXThe pilot was inspecting a herd of cattle when he thought the helicopter was developing a problem with the engine and main rotor. He started an autorotation, lost tail rotor control, and went into a left spin which continued to contact with the ground.…NTSB MKC89IA012Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Springfield, MOThe a.c. generator mounted on the left engine failed and resulted in an in-flight fire. The captain elected to shut down the left engine and divert the flight to the Springfield, Missouri regional airport. A single engine precautionary landing was completed…NTSB MIA89IA016Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · San Juan, PRThe acft departed runway 8 at 1810 ast. The plt reported a rt eng fire and declared an emergency. The acft was landed at 1815 ast, turned off the runway, and all the passengers were evacuated via the slides. According to maintenance personnel in San Juan, the…NTSB CHI89IA018Incident · No injuriesIncident investigationFinal reportBoeing B-727-200A · Chicago, ILOn departure from Chicago, Illinois, o'hare airport the aircraft experienced a loss of the inboard left main wheel. The aircraft diverted to detroit, Michigan, where it was landed with no damage to the aircraft and no injuries to the crew or passengers.…NTSB LAX89LA024Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Phoenix, AZDuring the landing roll, the airplane began to veer to the right. The pilot applied hard left rudder for a few seconds, then the left main tire came off the rim. Subsequently, the left gear collapsed and the airplane came to rest partly off the runway.NTSB LAX89DUJ02Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendale, AZDuring an aerial application flight the pilot reported that the right wing suddenly went up then down. The airplane rolled to the right and collided with the terrain. Inspection of the airplane revealed that the lift strut was broken. Evidence of corrosion…NTSB DEN89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Peyton, COA practice touch and go landing was being made on rwy 15, with winds reported as gusting to 20 knots. During the takeoff, the wing flaps would not retract and the aircraft climbed to 15 ft AGL. The pilot said he attempted to land after flying 500 yards and…NTSB FTW89DPA02Accident · Minor injuriesFinal reportPilatus B4PC11 · Bridgeport, TXThe glider was being tow-launched by an automobile from the pilot's private ranch airstrip. When the glider was approximately 250 feet AGL, the tow rope separated and the pilot attempted to return to the airstrip. A downdraft made this impossible and the…NTSB DEN89DTE01Accident · 1 fatalFinal reportHicks/Mervin RH-3 · Erie, CONTSB CHI89FA009Accident · 2 fatalField investigationFinal reportMooney M20J · Ludington, MIThe pilot in command failed to maintain proper altitude utilizing basic flight instruments while experiencing a loss of gyro instruments.NTSB ATL89DLT02Accident · No injuriesFinal reportSchweizer SGU-2-22E · Benton, TNAs the student pilot was attempting a dual aerial tow flight at 100 feet AGL, he experienced difficulty in staying behind the tow plane. The instructor took over the controls and while applying full right aileron noted no aileron movement. At 300 feet AGL the…NTSB MIA89IA008Incident · No injuriesIncident investigationFinal reportCessna 210M · Orlando, FLAfter takeoff when the ldg gear was raised, the plt noted that the gear motor circuit breaker popped and that he could not lower the landing gear using the emergency gear extension procedures. He landed gear up in the grass. Post accident investigation…NTSB MIA89LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLWhile practicing maneuvers near a grass airstrip, the left side of the engine cowling opened. The plt elected to perform a low pass to observe wind direction, then a precautionary landing at the airstrip. After touchdown, the acft became airborne and drifted…NTSB MKC89LA001Accident · No injuriesLimited investigationFinal reportSchweizer TG3A · Yoder, KSAn abrupt maneuver resulting in a stall/spin and subsequent aircraft control not being maintained by the pilot in command.NTSB ATL89LA001Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Ridgeland, SCThe plt reported that the left brake failed to function during taxi when he attempted to reduce speed and turn 180 deg into t/o position. The airplane began to track to the right. He released brake pressure on both pedals thinking that he might have been…NTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WINTSB NYC88DHM02Accident · Serious injuriesFinal reportAir Command 532 · Stormville, NYThe acdnt occurred as the non-certificated plt was operating the non-registered gyroplane in the traffic pattern. Witnesses heard a 'loud crack.' They then observed the gyroplane descending in an apparent unusual attitude. The gyroplane collided with trees,…NTSB FTW88DPJ13Accident · Serious injuriesFinal reportNord 1101 · Ardmore, OKImmediately after liftoff, the airplane abruptly turned left, nosed down, and struck the ground. Examination of the electrical pitch control of the propeller revealed the propeller blades to be in the high pitch, low RPM position. Due to extreme damage of the…NTSB BFO88LA084Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Princess Anne, MDThe pilot reported that he had sprayed aprx 1/2 of the soybean field when smoke started to fill the cockpit. He shut off the spray, turned off the electrical system and opened the fresh air vents. He then looked back at the tail section of the airplane and…NTSB LAX88DVA15Accident · No injuriesFinal reportSchweizer G-164A · Laton, CANTSB FTW88IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Dfw Airport, TXFatigue failure of the left main landing gear door actuator pivot trunnion shaft which subsequently became lodged in the actuator clevis preventing the door unlock mechanism from actuating during gear extension.NTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…NTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.NTSB LAX88DUG07Accident · No injuriesFinal reportBell 47G-5A · Perris, CAOn liftoff, tail rotor control was lost and helicopter spun with main rotor striking terrain. Investigation revealed fatigue failure of engine mounting cage. The eng basket had failed and allowed the t/r drive shaft to pull out of the coupling. The basket had…NTSB LAX88LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Truckee, CADuring takeoff roll the pilot heard a banging noise on the left wing. The pilot continued the takeoff. At 100 ft a.g.l. he executed a 180 degree turn to the right to return to land. The pilot added 30 degrees of flaps to the 10 that had been set for takeoff.…NTSB FTW88DPJ12Accident · 1 fatalFinal reportSnyder Stolp SA-300 · Oklahoma City, OKTotal failure of the rudder control due to failure of the metal welds on the cable attachment to the rudder pedal, due to improper welding by the manufacturer.NTSB DEN88IA207Incident · No injuriesIncident investigationFinal reportBeech 1900 · Denver, CONTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…NTSB DEN88MA203Accident · Minor injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Denver, COAs the capt was deploying reversers drg lndg, #2 & #3 reversers unlocked & deployed (green lgt cond), but #1 reverser was binding & only moved to the unlocked psn (amber lgt cond). Capt was not warned of this cond, though 2nd officer should have monitored…NTSB SEA88FA176Accident · 2 fatalField investigationFinal reportBell 204B · Entiat, WAThe acft was on contract to state of WA and working to suppress a forest fire using a water bucket suspended on a long line. The acft had refueled at a temporary heliport at Entiat, WA and was enroute to the work area 15 NM sw of Entiat but did not arrive at…NTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.NTSB CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…NTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…NTSB MKC88LA167Accident · Serious injuriesLimited investigationFinal reportSwearingen SA-226 · Emporia, KSWhile cruising at 17,000 ft, the 1st officer's rgt window panel failed & blew outward. A cabin decompression occurred & the copilot was seriously injured. The captain immediately descended to 10,000 ft & continued to their destination where an otherwise…NTSB CHI88FA226Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Toledo, OHFatigue fracture, for reasons undetermined, which lead to the loss of a propeller blade from the right engine. This in turn lead to the marginal controllability of the aircraft.NTSB MKC88LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. Louis, MOThe plt said that during a night takeoff roll, he noticed an inoperative airspeed indicator, and elected to abort the takeoff. Unable to stop in the remaining distance, the acft ran off the end of the runway onto the grass overrun collapsing the nose wheel.…NTSB CHI88FA223Accident · Minor injuriesField investigationFinal reportBoeing 727-31 · Chicago, ILImproper procedural checklist in which a critical step was not listed.NTSB LAX88LA303Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227-AC · Sacramento, CAMechanics failure to properly secure the right engine cowling after maintenance.NTSB FTW88LA152Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Sallisaw, OKAcft experienced a hard landing and rolled over following a loss of control in a hover. Plt delayed cutting the throttle in order to clear a ditch. Investigation revealed that the tail rotor driveshaft coupling retaining screw had separated. The separation…NTSB DEN88LA189Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Rawlins, WYNTSB LAX88DVA11Accident · 1 fatalFinal reportTedford VARI-EZE · Mariposa, CAAcft observed to dive into grnd. Investigation revealed inflt breakup and separation of canards. Exam of canards revealed modification to increase chord improperly done, adding excess weight aft of CG and making components subject to flutter. One mounting…NTSB MIA88FA260Accident · 6 fatalField investigationFinal reportPartenavia P-68C · Duncan Town, BahamasThe acft crashed in the ocean nr Duncan Town, Bahamas. The wx according to witnesses was VMC. The flt had been airborne enroute from nassau for about 1 hr and 20 minutes. Witnesses on a nearby boat said the acft was flying in a slight left bank when the left…NTSB SEA88LA155Accident · 1 fatalLimited investigationFinal reportMace R-2 · Reno, NVAcft had been fitted with new outer wing panels of elliptical design and was on sixth test flight for racing certification, exploring g envelope. Investigation revealed right outer panel separated in flight during maneuvering. Failure occurred in center…NTSB MIA88IA256Incident · No injuriesIncident investigationFinal reportBellanca 8KCAB · Miami, FLWhile on a personal flt during normal cruise, the plt reported that the cockpit filled with smoke. He turned off the electrical system & secured the eng, then attempted a precautionary landing on a grass strip. The acft landed long, overran the rwy, & nosed…NTSB CHI88FA205Accident · Minor injuriesField investigationFinal reportFairchild SA-226-TC · Cleveland, OHThe captain's late decision to abort after a propeller linkage failure on the right engine and the co-pilot's failure to relinquish engine and braking authority to the captain resulting in confusion and inadequate braking to stop on the runway after the abort.NTSB CHI88IA200Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILNTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…