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 FTW82DA117Accident · No injuriesFinal reportBeech C-18S · Hereford, TXThe pilot experienced total electrical failure during flight. Before landing he allowed the gear to free fall and attempted to crank it into the fully extended and locked position. When the crank would not turn he assumed the gear was in the locked down…NTSB ATL82LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-170 · Tuscaloosa, ALDuring an instructional flight the right engine was shut down and the prop feathered after a vibration was felt. The flight continued to its intended destination. Witnesses stated that they observed the right prop rotating while on final approach, even though…NTSB LAX82DA127Accident · No injuriesFinal reportGrumman G-164 · Bakersfield, CAOn takeoff roll the right main tire blew causing the aircraft to veer to the right, leave the runway, and nose over in the soft mud.NTSB FTW82FA111Accident · No injuriesField investigationFinal reportPiper PA-23-150 · Newark, TXThe plt reported a loud bang was heard and he observed the left eng cowl raised to a vertical position & the eng drooped downward. The excessive amount of drag caused the acft to be uncontrollable. The plt was able to gain control of the acft by feathering…NTSB NYC82FGM10Accident · 2 fatalFinal reportBeech E55 · Scandia, PAAt 0834 EST, the pilot departed bradford airport on an IFR flight to alton, IL. About 4 minutes later, he advised that he was having difficulty with his flight instruments while in IFR conditions. He attempted to return to the departure airport by using d.f.…NTSB DEN82DA055Accident · No injuriesFinal reportPiper PA-28R-201T · Longmont, COThe pilot reported that he made a normal approach and touched down in the landing zone as defined by the VASI. However, during the landing roll, the right brake was inoperative. He was unable to stop on the remaining runway while rolling straight ahead. About…NTSB ATL82FA092Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Baconton, GAAs the pilot was descending from 7000 to 5000 ft, he heard a loud bang, followed by a temporary vibration and a violent swerve to the right. He looked out the right window and thought the right engine had fallen off since all he could see was the tops of the…NTSB MIA82IA110Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tallahassee, FLWhile cruising at 8000 feet, the right alternator light came on and the pilot accomplished the required procedures for an alternator failure. Shortly thereafter, he noticed an area of discoloration on the inboard nacelle of the right engine and saw flames…NTSB SEA82DA044Accident · No injuriesFinal reportHiller UH-12E · Near Toutle, WAAbout 1 1/2 minutes after takeoff, the pilot heard a loud "bang" which was followed by a vertical and lateral vibration. The helicopter began to descend, pitch forward, and roll right as the vibration increased. The pilot elected to make an autorotative…NTSB CHI82IA112Incident · No injuriesIncident investigationFinal reportRockwell Sabreliner 65 · Detroit, MIThe right engine was started as the passengers completed boarding. After the copilot secured the cabin door and took his seat, the pilot released the parking brake and control lock and applied power to taxi. When a turn was commanded the nosewheel steering…NTSB FTW82FA108Accident · 1 fatalField investigationFinal reportGulfstream American 690C · Hughes, ARThe acft had been on sales demonstration flts and was on a delivery flt from memphis, TN to dallas, TX. The plane was observed departing at 1550 CDT in a max performance climb. Radar info from mode c of the transponder returns indicated that the acft climbed…NTSB CHI82IA102Incident · No injuriesIncident investigationFinal reportBeech 65-88 · Kalamazo, MIPrior to landing the pilot could not extend the right main landing gear. He attempted to extend the gear by recycling the system and by using the manual extension, but to no avail. Subsequently, the aircraft was landed on a paved runway with the gear…NTSB LAX82FA117Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Near Brideport, CAAfter taking off in a mountainous area, the pilot began climbing in up-currents on the side of a canyon. While following a ridge at about 100 ft AGL (11,000 ft MSL), he heard a loud noise that was followed by a shudder and vibrations. The helicopter began…NTSB FTW82IA146Incident · No injuriesIncident investigationFinal reportRockwell NA-265-80 · Houston, TXDuring taxi for takeoff, nosewheel steering was lost and the aircraft departed the taxiway and went down an embankment and into a drainage ditch causing minor damage. During the hydraulic system check-out, the hydraulic pump motor was found burnt out. The…NTSB MIA82DA074Accident · No injuriesFinal reportCessna T210M · Miami, FLThe pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up.NTSB MIA82DA071Accident · No injuriesFinal reportCessna 182H · New Port Richey, FLThe pilot stated that moments after takeoff power was applied the seat retaining pins broke, the pilot's seat moved aft breaking the rear retainer leaving him unable to reach the control yoke. The aircraft swerved off the runway and collided with trees. The…NTSB NYC82IA051Incident · No injuriesIncident investigationFinal reportNord 262A-12 · Flushing, NYWhile climbing through 7000 ft, the aircraft began to shake violently. The first officer confirmed that the source of vibration was the right engine. An unsuccessful attempt was made to feather the prop after the rt engine was shut down. The aircraft…NTSB SEA82FYK08Accident · Minor injuriesFinal reportKaman HH-43F · Sutherlin, ORThe helicopter was being used on a logging operation. After releasing a load from a hover out of ground effect, the pilot began to turn and accelerate. About two-thirds to three-fourths of the way through a 180 degree turn, the aircraft began a sudden, very…NTSB ATL82IA051Incident · No injuriesIncident investigationFinal reportBeech 200 · Birmingham, ALWhile climbing thru 500 ft AGL on takeoff, the manual pitch trim struck at 1 or 2 units nose up. Use of the three trim disconnect switches did not remedy the problem. About 30 secs later, the pitch trim ran away nose up and would not stop until the pitch trim…NTSB DEN82DA029Accident · Minor injuriesFinal reportMitsubishi MU2B-40 · Hayden, COThe aircraft was 20 feet AGL during landing when the crew heard a propeller go into beta mode and the aircraft yawed to the right. The pilot lost control of the aircraft and it collided with a snow bank which separated the wings from the fuselage. Impact…NTSB LAX82FA061Accident · 1 fatalField investigationFinal reportBell UH1B · Lagunitas, CAHelicopter crashed into a reservoir and sank in 60 feet of water after tail boom separated during a log slinging operation. The pilot had lifted and began to back up when a loud noise was heard and the tail separated. The log was released and an auto-rotation…NTSB SEA82FA032Accident · 4 fatalField investigationFinal reportCessna P210N · Boise, IDAfter takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…NTSB LAX82IA044Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · San Jose, CAThe aircraft was departing on an IFR flight from San Jose, CA to chester, CA. Shortly after liftoff at an altitude of about 50 feet AGL, the pilot heard a loud bang and the right front seat passenger informed him that the right propeller was missing. The…NTSB ATL82IA038Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Washington, DCAircraft was being ferried to Washington, DC following rework in toronto, Canada. During letdown in IFR conditions and moderate icing, pilot noticed a glow on the right wing. As he leaned over to check it, the right engine fire warning light and fire bell…NTSB CHI82IA026Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Chicago, ILThe aircraft had departed boston on a scheduled flight with the #1 generator placarded inoperative and noted in the minimum equipment list. En route to los angeles, CA at FL 350, about 80 mi northeast of bay city, MN., the crew noted a simultaneous loss of #2…NTSB ATL82IA034Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Clarksburg, WVDuring taxi out from greensboro, NC, the captain noted that the aircraft was pulling to the right. The problem alleviated itself when the pilot tapped the right brake. After a normal takeoff, the copilot noticed during gear retraction that the right main…NTSB DCA82AA009Accident · 2 fatalFinal reportPiper PA-31 · Ithaca, NYThe acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…NTSB ATL82IA029Incident · No injuriesIncident investigationFinal reportRockwell 114 · Pensacola, FLPilot advised approach control that he smelled smoke and had erratic engine instrument readings when 20 miles from destination. The gear was extended and three green lights observed but shortly afterwards the warning light and horn activated. During the…NTSB LAX82IA034Incident · No injuriesIncident investigationFinal reportPiper PA-24-180 · Van Nuys, CAThe pilot did not get a gear down indication prior to landing. The tower and the pilot of another aircraft observed the left main landing gear not fully extended. After attempting to extend the gear for about two hours unsuccessfully, the pilot landed gear up…