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 LAX85LA350Accident · No injuriesLimited investigationFinal reportCessna 182A · Santa Paula, CADuring a cross country flt the acft experienced fuel exhaustion and collided with ground obstructions during the subsequent forced landing in a river bed. The plt said 4 hrs and 20 mns of engine run time had elapsed since the last fueling of the acft. At the…NTSB FTW85LA320Accident · No injuriesLimited investigationFinal reportCessna 172N · Sallisaw, OKThe plt stated he had an electrical failure and elected to make a precautionary landing at Sallisaw municipal arpt. Equipment was on the rwy and the plt elected to land on a grass strip next to the rwy. He touched down and during rollout thought he could not…NTSB MKC85FA182Accident · 1 fatalField investigationFinal reportRonald Houk RD-1 · St. Charles, MOThe home built gyrocopter was being flown by the owner/builder/designer who had an airplane, single-eng, land rating. Shortly after the gyrocopter took off, the eng was operating at a high RPM when a witness heard a pop/noise. Subsequently, the gyrocopter…NTSB FTW85FA308Accident · No injuriesField investigationFinal reportFairchild Swearingen SA226TC · Dallas, TXThe aircraft sustained substantial damage when it landed with the gear up. The pilots reported lowering the gear, but did not confirm the gear position. The tower transmitted a warning, but the crew did not respond. Subsequent investigation revealed a…NTSB LAX85LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hesperia, CAUpon completing a x-c flt, the plt placed the landing gear selector in the down position, & thereafter observed 'three in the green.' The plt reported that the acft touched down normally, & as weight placed onto the gear the right main gear retracted. The…NTSB ATL85LA232Accident · No injuriesLimited investigationFinal reportCessna 150L · Hattiesburg, MSDuring a full-flap approach to landing, the pilot saw that the acft was going to land long and he initiated a go-around. He began retracting the flaps at the same time, and the acft started to settle. The pilot then elected to continue the landing straight…NTSB MIA85LA223Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Ochopee, FLThe plt stated that he dropped his passenger off at a water station in the everglades, water taxied away from the station, accellerated up to 3100 RPM & just before he added collective pitch the transmission ass'y departed the helicopter, it rolled to the…NTSB SEA85FA181Accident · 2 fatalField investigationFinal reportPiper PA-22 · Ketchum, IDStudent pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed…NTSB NYC85LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Duanesburg, NYAccording to the pilot, the aircraft landed and was taxiing to the fuel pump. The aircraft was moving fast and when the hand brake was applied it did not function. The pilot veered the aircraft off the runway in an attempt to slow it down. The aircraft rolled…NTSB DEN85LA199Accident · No injuriesLimited investigationFinal reportBeech 58P · Buena Vista, COThe left engine failed during takeoff at an altitude of about 40 ft AGL. During the forced landing, the plt used incorrect emergency procedures and failed to maintain lateral and directional control of the acft. Inspection of the acft revealed a disintegrated…NTSB MIA85IA217Incident · No injuriesIncident investigationFinal reportCessna 402B · West Palm Beach, FLAircraft experienced unsafe right main gear indication several days prior to the incident. Mechanics found a damaged micro switch mounting plate which they repaired enough to hold until a new plate could be ordered and installed. On day of incident pilot…NTSB DEN85LA195Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Riverton, WYThe plt was crop spraying a field in a Schweizer ag-cat acft when the left landing wire broke. The plt returned to Riverton, WY. During the landing roll, in attempt to stop the acft as soon as possible, he inadvertently applied the brakes too hard, causing…NTSB FTW85LA295Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · South MarshThe plt was initiating a takeoff from a hover off an offshore oil rig. As he lowered the nose for takeoff, he heard a loud noise emit from the tailboom area & the acft began rotating to the right. The plt continued to apply pwr and autorotated to the water.…NTSB MIA85LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe plt experienced an electrical failure while on a night flt & was unable to activate the rwy lights by keying his radio. He elected to land on the unlighted rwy without any landing lights rather than divert to another arpt. The plt stated that during the…NTSB CHI85LA302Accident · No injuriesLimited investigationFinal reportBeech E18S · Youngstown, OHDuring initial climb, the plt noted a vibration. He was unable to identify the source & elected to land gear up on the remaining rwy. An exam of the acft revealed that the stick shaker sys had been activated by an electrical problem in the left eng nacelle…NTSB ATL85FA216Accident · No injuriesField investigationFinal reportBell 206B · Anneville, KYThe pilot stated that the aircraft experienced hydraulic system failure followed by a loss of engine power. An emergency autorotation landing was attempted in a pasture and during the landing the aircraft was substantially damaged. Post crash examination…NTSB NYC85LA172Accident · No injuriesLimited investigationFinal reportBeech 36 · Calverton, NYThe pilot of N9031S was advised that nantucket memorial airport was in IFR conditions and decided to turn back towards long island. During the flight to long island, N9031S lost radio communications and soon electrical power to the navigational equipment. The…NTSB CHI85LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Appleton, WIAs the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and…NTSB MKC85LA157Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Earle, ARThe plt reports that the propeller ran away when the acft was at 75 ft AGL on final apch for landing at a pvt airstrip. The plt said he was to low to correct the propeller malfunction and was forced to land in a bean field adjacent to the strip. An FAA…NTSB FTW85FA283Accident · No injuriesField investigationFinal reportGates Learjet 35A · Fort Worth, TXThis acft ran off the departure end of the 4001' runway following a normal approach, touchdown and initial braking. After about 1000' of norm braking, the acft began a drift to the right which was partially overcome by full left rudder and asymmetrical…NTSB ATL85LA207Accident · No injuriesLimited investigationFinal reportCessna 150 · Geneva, ALDuring instructional flight acft collided with trees after takeoff. Instructor said flaps would not retract while in go around. Acft owner told FAA inspector instructor told him flaps would not retract after final landing. Fuse was then replaced with no…NTSB DEN85FA180Accident · 4 fatalField investigationFinal reportHughes 369HS · Keystone, SDMain rotor hub was overhauled by a repair station that was not authroized by Hughes helicopters for hub overhauls. The main rotor hub and blades separated in-flt 279 hrs after overhaul. The acft crashed in a densily wooded area. Post accident exam of the main…NTSB MIA85LA207Accident · No injuriesLimited investigationFinal reportQuinn EL Tomcat MK-5A · Blakley, GAWhile en route to reposition the helicopter to another farm, the eng lost power. The plt reported that during an autorotation, the main rotor lost some RPM as he stretched his glide to avoid a fence. As the helicopter touched down on uneven terrain, the main…NTSB MIA85FA202Accident · Minor injuriesField investigationFinal reportPiper PA-32RT-300T · Pembroke Pines, FLThe acft experienced a complete in flt loss of his prop after departure from north perry arpt hollywood FL due to a fatigue failure of the prop hub. The fatigue cracking was due to residual stress resulting from deformation of the material in the hub ass'yNTSB CHI85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Oxford, OHWhile on a round-robin flight at night the pilot experienced an alternator failure. As he was returning to his point of origin the battery power depleted leaving him with no radios or landing light and only a flashlight for cockpit lighting. He decided to…NTSB LAX85IA297Incident · No injuriesIncident investigationFinal reportBoeing 737-247 · Los Angeles, CAThe captain stated that the 'b' hydraulic system low oil leval lamp illuminated while the acft was in cruise flt. As he completed the failure check and placed the 'b' system into standby rudder condition that provides hydraulic pressure to only the rudder,…NTSB DCA85AA027Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · San Juan, PRAfter landing at San Juan, the acft was parked at the customs area, then was towed to gate 15 & loaded for the next flt. The push-back was such that the crew had to taxi to the gen avn parking area & turn around bfr proceeding to rwy 8 for departure. When…NTSB FTW85FA265Accident · 1 fatalField investigationFinal reportAerospatiale AS35OD · Dallas, TXThe eng to transmission short shaft became disconnected in flt. This resulted in complete loss of pwr to the main rotor assembly. However, the tail rotor assembly was still being powered by the eng. Upon collective pitch application to stop the descent the…NTSB NYC85FA155Accident · 1 fatalField investigationFinal reportBeech B95A · Readington, NJPapers were observed to fly out of the acft during takeoff. The acft was observed to 'waver' with the gear down & crash to the ground several minutes later. An exam of the cabin door revealed that it had popped open in flt.NTSB MIA85IA203Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2K · San Juan, PRAfter departure the nose gear unsafe light remained illuminated peter gear retraction. Attempts to get a safe light on the nose gear in the extended position was unsuccessful and when the aircraft landed it settled onto a partially retracted nose gear.…NTSB CHI85FA251Accident · 1 fatalField investigationFinal reportNeumann-Everett N2 · Cambridge, MNThe newly rated prt plt was on his 12th flt in the recently certificated homebuilt that he had designed and built himself. While performing an unknown maneuver both horizontal stabilizers and both wings separated from the acft. The acft was restricted from…NTSB CHI85LA247Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe glider landed in trees after the spoiler 'popped' open in flt during a towed takeoff. The tow plane released the glider at 300 ft AGL after the spoilers opened. The plt landed without retracting the spoilers. Two FAA inspectors stated that they checked…NTSB DEN85LA173Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Deming, NMThe plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n…NTSB ANC85LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mulchatna River, AKPlt reported that left wheel axle broke during aborted takeoff from gravel bar, causing acft to ground loop. Plt failed to provide complete info & broken axle for analysis.NTSB ANC85LAG01Accident · Minor injuriesFinal reportBrians Puffin · Eagle River, AKThe plt was conducting taxi tests on his homebuilt acft when it started to sustain a hull structure failure and control interference from separating parts. The acft pitched off the water, climbed to aprx 100 ft AGL, stalled and spun to ground impact.NTSB FTW85LA256Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownsville, TXThe ag acft was destroyed when it failed to pull out of an aerial application maneuver following the initial swath run over a field. The plt stated that after making his turn to return to the field, he attempted to level the acft and received no response from…NTSB ANC85LA095Accident · No injuriesLimited investigationFinal reportCessna 185 · Kantishna, AKThe plt was on a flt from fairbanks to Kantishna, AK; however, the rwy at Kantishna was muddy, so he elected to return to fairbanks. While returning, he elected to land at an abandoned mine strip for a comfort stop. During the landing, a hydraulic line to the…NTSB ATL85LA184Accident · No injuriesLimited investigationFinal reportCessna T337G · Knoxville, TNThe acft made an emergency gear up landing when both the normal and emergency extension systems failed to function properly. A mechanic was later able to extend the gear with the acft on jacks by repeatedly cycling the selector switch. It was determined that…NTSB MKC85IA131Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · St. Louis, MOWhile on an IFR approach to land at stl and the plt initiated flaps. The no.3 outboard flap vane separated from its mounting and fell to the ground. Upon separation the flap vane struck the leading edge of the trailing edge flap knocking a hole in the skin.…NTSB FTW85LA249Accident · No injuriesLimited investigationFinal reportCessna 310F · Midland, TXOn takeoff, the plt heard a loud bang when he cycled the gear up and he got a gear unsafe light. Personnel on the ground advised him that the nose gear was hanging down at a 45 degree angle, but the mains were up. The plt diverted to a nearby arpt that had…NTSB NYC85LA140Accident · No injuriesLimited investigationFinal reportCessna 340A · Butler, PAThe plt reported that prior to the flt, he made the usual preflight check & locked the left forward, nose baggage door. During the takeoff roll, the left forward baggage door opened & locked in an upright position. The plt aborted the takeoff, but there was…NTSB ATL85IA180Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA226TC · Cherry Point, NCDuring an appch for ldg at new bern NC, the crew was unable to get the right main ldg gear to extend. Ground observers reported that the right gear door was partially open. The crew elected to divert the commuter air carrier flt. To mcas Cherry Point where…NTSB MIA85LA183Accident · Minor injuriesLimited investigationFinal reportCentrair Pegase 101A · Jacksonville, FLThe plt stated that on initial climb, realizing he had no elevator control, released the tow rope than deployed the spoilers and collided with the ground. Post crash examination of the wreckage revealed the elvator cable was not connected.NTSB BFO85IA050Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30F · Chantilly, VAAfter climbing up to and leveling off at 37,000 feet, the crew of the DC-10-30F noticed that the york control of the captain and the first officer moved laterally independently of each other for approximately two inches. After making an unscheduled uneventful…NTSB CHI85LA219Accident · No injuriesLimited investigationFinal reportCessna T210 · Marion, INShortly after takeoff, the plt discovered that the elevator controls were jammed & pitch changes could only be made with elevator trim & power. An emerg landing was made using the trim, but the plt was unable to flare the acft at landing speed. The acft…NTSB LAX85LA264Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · San Jose, CAWhile landing the right main landing gear of the aircraft seperated when the upper torque knee link failed. After the gear separated the aircraft skidded off the right side of the runway coming to rest in a grass area. Metallurgical examination of the failed…NTSB LAX85LA263Accident · No injuriesLimited investigationFinal reportCessna TR 182 · Mesa, AZDuring initial climb on a dual instructional flight a fire erupted behind the instrument panel & the acft was returned for landing. During roll out 6 inch long flames, smoke & noxious fumes filled the cockpit. When the acft slowed to 10 mph the plts exited…NTSB NYC85FA138Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYThe forward one-third portion of the core cowl door on no. 3 engine separated in flight first striking the leading edge of the right wing, then puncturing the fuselage. Causing rapid decompression at FL 170. The core cowl door latches were not adjusted & core…NTSB CHI85IA212Incident · No injuriesIncident investigationFinal reportBoeing 727-023 · Chicago, ILAmerican airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all…NTSB CHI85FA209Accident · 1 fatalField investigationFinal reportHeekin B-8-M · Williamsburg, OHWitness reported hearing a loud bang and seeing the main rotor blades stopped. The gyrocopter was then observed rotating slowly in a clockwise direction to ground impact. The wooded prop (engine driven) was demolished with portions of it found up to 300 ft…