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 LAX83FU001Accident · 1 fatalFinal reportMitchell A-10 · Tulare, CAThe ultralight was on a demonstration flt. Reportedly, the plt made a pass down the rwy, then had turned downwind at 400 to 500 ft, when witnesses heard a loud bang or crack & saw the wings of the vehicle fold. The ultralight then entered a spiral & crashed…NTSB NYC83FU002Accident · Serious injuriesFinal reportCGS Hawk · East Hanover, NJDuring takeoff, the plt heard a bang as the propeller (prop), attaching pulley & reduction drive belts separated, while the ultralight vehicle was climbing thru about 130 ft AGL. At that time. The eng began overspeeding, the nose pitched up & the ultralight…NTSB MKC83FA084Accident · No injuriesField investigationFinal reportCassutt III M Sport · Hiawatha, KSWhile en route at 5500 ft MSL, the plt noticed an oil film start to cover the windshield of the home built acft. At that time, he was approaching hiawath, KS, so he diverted to the Hiawatha arpt. By the time he entered the traffic pattern to land, the oil…NTSB LAX83LA167Accident · No injuriesLimited investigationFinal reportBeech A56TC · Lost Hills, CAThe plt stated that during the landing roll-out, the left main tire blew out and before the plane was stopped, the left main gear collapsed. Reportedly, he had made a normal approach and did not use heavy braking action. The 2 passengers and a witness…NTSB FTW83LA169Accident · Minor injuriesLimited investigationFinal reportBeech 35 · El Paso, TXOn a flt after an annual inspn, the plt could not retract the gear, using the normal electrical sys. It remained extended with the green safe light on & the gear pointer indicating down. He tried to assist the normal sys with the manual handcrank, although…NTSB ANC83IA060Incident · No injuriesIncident investigationFinal reportCessna C-207A · Eek, AKDuring landing roll the left brake did not respond to the pilots commands. The acft veered off the right side of the runway. The aircraft had maintenance performed on the brakes 2 days before.NTSB LAX83LA152Accident · No injuriesLimited investigationFinal reportCessna 182A · Torrance, CAThe plt stated that when he reached aprx 60 ft AGL during takeoff, he noticed the airspeed indicator drop below 40 mph. He said the eng sounded normal. He lowered the nose of the acft, but the airspeed indicator reading remained below 40 mph, so he elected to…NTSB ATL83LA142Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MSThe plt reported that during takeoff, he had reached an alt of aprx 100 ft AGL, had reduced power & was retracting the flaps from the takeoff setting when he felt the acft 'give.' He reextended the flaps, applied full throttle & dumped his load, but the acft…NTSB NYC83IA080Incident · Minor injuriesIncident investigationFinal reportBritten-Norman BN-2 Mark III · Blue Bell, PAA deicer boot on a right propeller blade separated. It struck & broke a window. A tie strap was missing. There was no evidence of improper or inadequate bonding.NTSB CHI83FA148Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rochester, ILThe acft experienced an in-flt break-up during descent. The pilot had reported on the radio to Kansas city ARTCC that hewas having severe chest pains and shortness of breath. Radar contact with the plane was lost at 1425 CST. The pilot had reported he was…NTSB MIA83LA102Accident · Serious injuriesLimited investigationFinal reportGemini Int'l. Humingbird · Lakeland, FLThe acft landed hard and collapsed the nose gear after one engine failed during takeoff. The acft had made one takeoff and landing and was beginning a second. As the acft rotated the left engine failed due to the throttle linkage becoming disconnected. The…NTSB MIA83IA098Incident · No injuriesIncident investigationFinal reportCessna 402C · Near Taylor, FLA propeller blade separated due to a fatigue failure.NTSB SEA83FA065Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Longview, WASeveral persons saw the helicopter flying at a cruising altitude of about 200 to 300 ft, then enter a loop type of maneuver. They lost sight of the helicopter near the bottom of the maneuver before it crashed. The plt received serious head injuries & could…NTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…NTSB SEA83FU001Accident · Serious injuriesFinal reportWeedhopper 1 · Woodinville, WAThe plt took off in an ultralight vehicle from a sod field. Witnesses observed that the right wing tip was dropped during the takeoff. At aprx 200 ft AGL, the vehicle entered a right spiral & impacted the ground. The lower, right wing, left/drag strut pin was…NTSB FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…NTSB MKC83FA076Accident · 2 fatalField investigationFinal reportRobinson R-22 · St. Louis, MOThe helicopter was observed by several witnesses flying at 200-300 feet above the Mississippi river. As it wobbled and buffeted and rolled to the right. It was spinning and the tail rotor separated shortly followed by an explosion with a blueish/white smoke…NTSB MIA83LA091Accident · No injuriesLimited investigationFinal reportGray J-3 Trainer · Lakeland, FLWhile maneuvering to enter the ultralight landing area on the arpt during an eaa fly-in, the elevator became jammed in the down position when a bolt in the linkage became jammed against the wheel axle which had been bent in a previous accident. The plt was…NTSB DEN83FTE07Accident · 1 fatalFinal reportHomebuilt Rotorcraft Z6 · Bennett, COThe Homebuilt gyrocopter crashed on level terrain after rudder and rotor blade separation in flt. The rudder was found about 100 yards from the main wreckage. It had been struck by one of the rotor blades and had separated in flt. The separated rotor blade…NTSB LAX83LA127Accident · Minor injuriesLimited investigationFinal reportCessna 310C · San Jose, CAThe plt reported that when he was taking off, he heard a noise, during gear retraction, that sounded to him like an explosion & the gear-up light did not illuminate. He then tried to extend the gear, but was unable to get a safe-down indication. He was able…NTSB LAX83FA124Accident · 1 fatalField investigationFinal reportThorp T-18 · Simi, CAThe acft crashed in a school playground in a steep uncontrolled descent. Witnesses said the acft was observed in a 60 degree nose down attitude at about 1000 ft AGL and this continued until ground impact. The engine was producing high power at this time. No…NTSB LAX83FA121Accident · 2 fatalField investigationFinal reportHughes 269A · Phoenix, AZThe purpose of flt was to take aerial photogrphs of a business agency near the crash site. The helicopter was observed orbiting a parking lot in a right hand pattern at 150-300 ft AGL. After 2-3 orbits it appeared to hover before pitching nose down to a near…NTSB ANC83IA056Incident · No injuriesIncident investigationFinal reportCessna 172M · Wasilla, AKAcft experienced failure of the left flap during climbout due to worn parts which were not observed on the preflight inspection.NTSB ATL83FA122Accident · No injuriesField investigationFinal reportBell 47G-2 · Hardeeville, SCThe plt stated that he noticed a peculiar pedal reaction during a turn-around; however, he reported that this may have been caused by the wind which was gusting to 15 KTS. Shortly after completing the turn-around, he experienced a complete loss of tail rotor…NTSB LAX83LA117Accident · No injuriesLimited investigationFinal reportBell BH 206-L111 · Peach Springs, AZAfter the rotorcraft took off to a hover the pilot did a pedal turn for a down canyon departure. After the hover turn the pilot slid to the right to clear some obstacles and when the rotorcraft moved laterally about 25 feet the pilot heard a bang. The left…NTSB ATL83LA119Accident · No injuriesLimited investigationFinal reportCessna 210 · Folkston, GAShortly after departure, the pilot observed fuel coming from the fuel tank vent and elected to make a precautionary landing. He touched down in the first 1/3 of runway 17 at a speed of about 80 mph. The pilot stated that the brakes failed during the roll-out…NTSB MIA83IA075Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Miami, FLDuring gear retraction after takeoff, the aircrew noted that the left main landing gear (MLG) door warning light remained illuminated. The landing gear control was cycled, but the condition was not corrected. Attempts to extend the left MLG were also…NTSB FTW83LA122Accident · No injuriesLimited investigationFinal reportMonnett Sonerai II · Las Cruces, NMThe new home built acft had only 2.5 hrs total flt time. After a test flt, the plt was on the landing roll when he lost control at aprx 35 mph. Subsequently, the acft ground looped & nosed over on its top. The plt reported that loss of control occurred after…NTSB LAX83LA103Accident · No injuriesLimited investigationFinal reportBeech 95-55 · San Francisco, CAThe pilot was preparing to taxi when he noticed a loose fuel cap on the acft's left wing. He set the parking brake, exited the acft with both engines operating, placed a chock on the right wheel and was securing the loose fuel cap when the acft started to…NTSB FTW83LA119Accident · No injuriesLimited investigationFinal reportCessna 150G · Dalhart, TXThe plt stated that shortly after takeoff, he smelled fuel & observed a wet spot on the right side of the cockpit floor. He executed a precautionary landing, taxied to the ramp & shut down the engine. As he pulled the mixture control aft, flames erupted from…NTSB ATL83LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paducah, KYThe acft was damaged during an autorotation into an open field after a chip detector light illuminated. The chip light is used for detecting metal in the transmission, engine and tail rotor gear box. Examination of the transmission revealed metal particles on…NTSB MKC83LA068Accident · No injuriesLimited investigationFinal reportCessna R182 · Olathe, KSPrior to landing, the pilot was unable to extend the left main gear and elected to land with all gear retracted. An investigation revealed that a bolt in the left main gear brake assembly was loose and jammed the wheel in the wheel well. An annual inspection…NTSB CHI83LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Bellefontaine, OHThe acft ground looped off the runway during a takeoff. The solo student said he encountered nosewheel shimmy during thetakeoff roll. He raised the nose to stop the shimmy and looked at his airspeed indicator. At about that time, the acft weathervaned to the…NTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…NTSB CHI83IA105Incident · No injuriesIncident investigationFinal reportGates Learjet LR-25 · Wilkes Barre, PAAcft autopilot/autotrim system failed to disengage due to a malfunction of the engage switch which occurred only in cold environment.NTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…NTSB MIA83FKA01Accident · 1 fatalFinal reportBensen B8M · Patillas, PRThe gyrocopter crashed during takeoff after climbing to about 50 ft. AGL. This was the seventh takeoff of the day for this flt. The pilot lost control of the acft and it dove vertically to the ground. Investigation of the wreckage revealed that the cyclic…NTSB ATL83FA091Accident · 4 fatalField investigationFinal reportMooney M-20A · Prattville, ALThe left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…NTSB CHI83IA091Incident · No injuriesIncident investigationFinal reportGates Learjet 24 · Cleveland, OHThe nosewheel steering mechanism was activated at too high aspeed after touchdown causing a loss of control. There were prior instances of steering problems which were not documented in maintenace records & the plt was not aware that they existed.NTSB MKC83LA058Accident · No injuriesLimited investigationFinal reportBeech D55 · Cape Girardeau, MOThe aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…NTSB LAX83IA080Incident · No injuriesIncident investigationFinal reportBoeing 767-231 · San Diego, CAWhile descending thru 12,000 ft aprx 40 mi east of San Diego, CA, the left overwing evacuation slde annunciator light illuminated. The slide separated from the acft aprx 7 mi east of the arpt. No flt control problems were noted. Integrity of the sys was found…NTSB NYC83LA053Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · New Cumberland, PADuring the takeoff roll at about 117 KTS, the acft began to vibrate, pull to the left and decelerate. The takeoff was aborted. The acft continued off the left side of the rwy and came to stop against a small embankment. An exam of the rwy reveal tire markings…NTSB LAX83LA074Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Dixon, CAReportedly, the acft was on an air taxi cargo flt, operated by air express, hayward, CA. The acft reportedly departed reno, NV without a flt plan for a flt to sacramento & hayward, cal. While en route, the acft had an electrical failure. The plt stated that…NTSB ANC83LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Nondalton, AKThe plt reported that during a landing on an ice & snow covered rwy, the braking was poor & he was using pumping actions while applying the brakes. Reportedly, when the acft was about half way down the rwy, the left brake lost all pressure. At about the same…NTSB FTW83FA088Accident · Serious injuriesField investigationFinal reportCessna 172N · Carrollton, TXThe plt reported that during arrival, he entered the downwind with no problem; however, when he attempted to turn on a left base, the aileron control locked up. He stated he could turn neither left nor right by using ailerons. Reportedly, the acft would bank…NTSB FTW83IA084Incident · No injuriesIncident investigationFinal reportBell 222 · Houston, TXThe helicopter developed a severe vibration while in flt. The pilot executed an emergency landing with no further acft damage. An examination of the acft revealed that the walking beam assembly located between the swash plate and rotor pitch link had failed.…NTSB MKC83IA054Incident · No injuriesIncident investigationFinal reportCessna 402B · St. Louis, MOThe right engine of the acft started to burn while the acft was being started. The pilot noticed flames coming out of the top of the right engine after the left engine was started. The pilot initiated shut down of both engines and evacuation of the…NTSB ANC83FAG02Accident · Serious injuriesFinal reportWillbird 2 · Chugiak, AKAs the aircraft lifted off, the nose pitched up alarmingly and application of full down elevator control had no apparent effect. The pilot was able to lower the nose by extending full flaps. However, he was unable to latch the manual flaps in the down…NTSB DEN83LA046Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 (Soloy) · Great Falls, MTWhile maneuvering at low altitude in search of animals, the pilot experienced a severe vibration through the flight controls. The helicopter began an uncontrolled descent and attempts to stop the descent by using the collective were unsuccessful. The…NTSB ATL83LA082Accident · No injuriesLimited investigationFinal reportCessna T210L · Horse Cave, KYThe pilot reported that he encountered turbulence, and at about the same time, the engine began running rough. He began troubleshooting and discovered that the roughness was directly proportional to throttle movement; when the throttle was advanced, the…