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 FTW85FPA02Accident · Serious injuriesFinal reportBeech H35 · Wichita Falls, TXThe acft made a shallow rt turn and descended to ground contact during a go-around after the plt was informed by radio that his landing gear was not fully extended. Investigation revelaed also that the main fuel tanks were empty and the tank selector was on…NTSB FTW85LA229Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · San Angelo, TXA piece of unidentified equipment reportedly was not properly secured during previous maintenance. The equipment reportedly was mounted immediately above the nose wheel extension/retraction mechanism and moved due to acft vibration preventing the nose gear…NTSB ATL85FA168Accident · No injuriesField investigationFinal reportEmbraer EMB-110-P1 · Atlanta, GAThe acft was on final apch when the circuit breaker caution light illuminated. The PIC failed to verify which cb tripped and assumed it was the gear control cb. PIC then activated emerg hydraulic sys and manually lowered the gear. After landing the hydraulic…NTSB SEA85FA110Accident · 1 fatalField investigationFinal reportCessna 402 · Pocatello, IDShortly after departure & level off, the plt reported an eng malfunction & initiated a return to the arpt. About 2 min later, he reported an eng fire & declared an emergency. Aprx 1 min thereafter, the rgt wing separated from the acft & the plane crashed. An…NTSB MIA85LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Lakeland, FLDuring takeoff at Lakeland, FL, the left main wheel assembly separated from the acft & struck the leading edge of the horizontal stabilizer, causing substantial damage. The plt did not know the wheel had come off until he was notified by ATC. He then diverted…NTSB ANC85LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKWhile cruising at about 2000 ft, the top eng cowling came off, rupturing an eng oil line & breaking a hole in the left side of the windshield. Oil then covered the windshield. Due to the loss of oil, the plt shut down the eng & landed on a beach. During the…NTSB ANC85IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Cape Simpson, AK# 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.NTSB MKC85FA100Accident · 2 fatalField investigationFinal reportBell 47G · Calwood, MON951B crashed in a wooded area during a powerline patrol flt which included photography of the powerline. According to witnesses, the helicopter was flying parallel to the powerline in a westerly direction when the accident occurred. Exam of the wreckage…NTSB LAX85FA240Accident · No injuriesField investigationFinal reportDouglas DC3 · Perris, CAThe aircraft's left engine caught fire during the takeoff roll. The pilot managed to stop the aircraft on the runway and all 31 skydivers and the two member crew evacuated without injury. The left engine propeller had lost one blade which was found several…NTSB FTW85FRD01Accident · Serious injuriesFinal reportAlon A-2 · Bunkie, LAThe acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…NTSB MIA85LA164Accident · No injuriesLimited investigationFinal reportMooney M20C · Bainbridge, GAWhile en route, the plt noted a severe eng vibration. He shut down the eng & made an emergency landing. During the roll-out, the acft hit a ditch & was damaged. An investigation revealed that one prop blade had failed from fatigue & the end of the blade had…NTSB BFO85FA041Accident · No injuriesField investigationFinal reportMooney M20F · Stevensville, MDThe plt stated that when in normal curise at 3000 ft over castle marina arpt he noticed excessive oil and cylinder head temps. A concurrent small amount of smoke was emanating from the instrument panel which prompted the plt to execute a precautionary lndg at…NTSB FTW85LA201Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ama, LAThe aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used…NTSB CHI85LA177Accident · No injuriesLimited investigationFinal reportCessna T210L · Minneapolis, MNAfter lowering the landing gear, the pilot heard a loud 'thump'. A gear down & locked indication was not obtained, however, the main gear appeared to be down to the pilot. Upon landing the acft swerved off the side of the runway. Only the right main gear was…NTSB DCA85IA019Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Detroit, MIThe flt crewmembers of the jumbo jet were preparing to start the engs when flt attendants (f/a's) in the forward cabin detected a faint odor prior to closing door 1L. The source could not be determined, so the door was closed in preparation for a pushback.…NTSB MIA85IA155Incident · Minor injuriesIncident investigationFinal reportGrumman G-73-T · St. CroixWhile on an FAA observed proving flight, water take off, the left propeller electrical terminal failed. The part then penetrated the left forward passenger window and struck the FAA observer causing minor injury. The plastic part failed in over load due to…NTSB LAX85FUG03Accident · Serious injuriesFinal reportVickers Slingsby T56A Vega · Hemet, CAThe sailplane was in level flt when the plt felt flutter and lost pitch control of the acft. After one uncontrolled loop the plt bailed out and received serioud injuries during the parachute landing. Loss of all six elevator hinges had caused the elevator to…NTSB ANC85LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga, AKThe plt stated that the right ski hit something during the takeoff run & bent the right main gear/ski down & aft. He elected to land on snow covered terrain near the small village of Beluga, AK. Before coming to rest during the landing, the acft went over on…NTSB MIA85FA153Accident · 3 fatalField investigationFinal reportSikorsky S-58ET · Gulf Of MexicoThe helicopter disappeared while on an overwater flt from key west, FL to ft peirce, FL. One occupant & the wreckage of the helicopter were subsequently recovered from the Gulf Of Mexico. The plt & the other occupant were not located & were presumed dead.…NTSB CHI85LA168Accident · No injuriesLimited investigationFinal reportWheat Pitts S-1-S · Marlette, MI100 Yards from end of rwy on final apch plt lost rudder control. During landing roll as airspeed and aileron control effectiveness decreased the acft veered off the side of the rwy. The lower left wing contacted a VASI light. Inspection revealed right side…NTSB FTW85LA190Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Junction, TXAfter normal apch and landing the acft began vibrating when the tailwheel touched down. The acft became uncontrollable as the airspeed decreased below 30 KTS. Resulting in a ground loop and dragging of a wing tip. Investigation revealed that the tailwheel…NTSB FTW85FRA03Accident · 2 fatalFinal reportCondor Condor III · Hockley, TXThe acft collided with the terrain in a near vertical descent. Witnesses stated the ultralight was airborne for aprx 5 minutes before a loud 'pop' was heard and it entered a steep nose down spiral. Inspection of the ultralight revealed a failed bolt in the…NTSB LAX85IA206Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Las Cruces, NMWhile cruising at flt level 350 in clear smooth air, a loud noise was heard, accompanied by a severe jolt on the right side of the cabin, as the number 3 end separated from its mounts. Subsequent investigation disclosed that the forward lavatory was leaking…NTSB FTW85FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Franklin, LAAcft crashed into a crawfish pond during a forced landing at night following a power loss as a result of fuel exhaustion. After departure, the plt contacted ARTCC and stated that his alternator was out. With center help, alternator was restored and plt cont'd…NTSB DEN85FTE01Accident · 2 fatalFinal reportUltralight Flight Phantom II · Erie, COThe Ultralight descended uncontrolled to ground impact following a failure of the outboard forward wing support cable/swage. Witnesses reported the Ultralight turned from north to south and upon leveling out, the left wing snapped upward, the right wing…NTSB BFO85LA039Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Alta Vista, VAEach time the pilot applied nose up pitch control after take off, the acft settled but would maintain straight and level flight when the controls were neutralized. Due to the settling effect, obstruction clearance could not be attainedand the acft settled…NTSB BFO85IA035Incident · No injuriesIncident investigationFinal reportBoeing 737-217 · Chantilly, VAApprox 25MIN aft lndg,flt 168 was cleared for tkof on rwy 30 at dulles intl arpt. Abt 1MIN later the crew called for an aborted tkof because the #2 epr appeared slow to spool up. Aft taxiing back and running up the engines, flt 168 atmptd a second tkof. Dfdr…NTSB MIA85IA147Incident · No injuriesIncident investigationFinal reportHawker Siddeley HS-125 · Ft Lauderdale, FLThe plt reported that on an FAA check flt, the nose gear would not extend. Subsequently, the acft received minor damage when it was landed with the nose gear retracted. An investigation revealed that a nose landing gear door rod assembly had failed from…NTSB ATL85IA132Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Marion, ALCruising at 4000 ft MSL when engine vibration occurred and became severe. Reduced throtte but roughness persisted. Unable to mntn altitude with 2000 RPM and 25 inches map. Made forced ldg in corn field. Nose ldg gr collapsed. Engine checked out okay. One…NTSB CHI85IA160Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Dayton, OHOn short final at an airspeed bet 120 and 125 KTS full flaps were lowered for landing. When the flaps reached the full down position, the stall warning horn came on and the stick pusher on the rosemont stall avoidance system activated. The captain disengaged…NTSB MIA85FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 7B · Orlando, FLThe Balloon was destroyed by an explosion and subsequent fire during touchdown in an open fld. The plt and witnesses stated the gondola touched down with a 'jolt' and tilted in the direction of travel. Shortly thereafter, a popping noise was heard followed by…NTSB LAX85LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · Eagle Mountain, CAAccording to the riverside county California sheriff's department the acft touched down left gear first and experienced a blowout or gear failure on the right gear. The acft ran off the right side of the rwy, skidded across a dirt berm partially separating…NTSB NYC85FA092Accident · Minor injuriesField investigationFinal reportSikorsky S-55B · Port Elizabeth, NJThe helicopter landed hard after a decrease in RPM during initial climb. The acft was being used for a sling operation. Investigation revealed a failed clutch assembly, S1435-2500-1. The clutch had operated only 200 hrs since a major overhaul.NTSB MIA85IA137Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe acft veered off the left side of rwy 9R on landing. Inspection of the acft revealed that the torque link washers on the left main landing gear had failed allowing the wheel assembly to rotate causing the loss of directional control. No record of…NTSB MIA85LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Key West, FLAfter the acft departed the seaplane parking area, the plt noticed that the left float was taking on water. He initiated a turn back towards the ramp area & applied full power in an attempt to reach shallower water. As he apchd the parking area & was turning…NTSB NYC85FA088Accident · Serious injuriesField investigationFinal reportLake LA-4-200 · Swanton, VTDuring normal cruise flt the plt became unable to move the elevator control. The flt was continued to the planned destination using elevator trim for pitch control. On final approach to the rwy the acft was caught by a wind gust & pitched nose down. The plt…NTSB MIA85LA131Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Fort Myers, FLThe acft landed with both main wheel brakes locked as evidenced by skid marks in the touchdown zone of the rwy. After aprx 200 feet of skidding the left brake released and due to the right brake not releasing the plt lost control. The acft veered off the…NTSB NYC85LA087Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Zelienople, PAThe acft collided with trees shortly after takeoff. Prior to takeoff the plt was made aware that the lock cylinder for the cabin door was broken. Upon reaching an alt of 1800 ft, the cabin door popped open. The plt attempted to secure the door after…NTSB MIA85LA132Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Pierce, FLTakeoff run was reported to be normal. After lift off the aircraft would not climb and engine RPM was noticed to be 300 RPM low. The aircraft descended and struck a pine tree at the end of the runway. The aircraft was being operated within 60 pounds of the…NTSB FTW85LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXPlt raised landing gear during initial climb after takeoff and received no reaction from either the gear retraction sys or the gear indicator sys. After troubleshooting the sys, the plt elected to make a low pass by the tower, during which the gear appeared…NTSB NYC85LA086Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Fairfield, PADuring flt, the acft had an electrical problem while flying in instrument (IFR) conditions. The plt reported that only the altimeter, airspeed indicator & mag compass were operating. He became spatially disoriented & the acft entered several dives & at least…NTSB LAX85LA186Accident · No injuriesLimited investigationFinal reportCessna 182P · Gila Bend, AZWhile in cruise flt the acft's high voltage warning light illuminated and the alternator circuit breaker popped out. The plt reset the breaker which restored operation to the circuit. Later in the flt a fire erupted behind the instrumentpanal and soon…NTSB CHI85LA147Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Flora, INPilot dept danville, IL no flt plan for indianapolis, IN enroute he encountered IFR conditions and reversed course. The pilot then lost all electrical power on acft. Flying north, pilot saw Flora muni thru breaks in overcast. Pumped gear down and only…NTSB MIA85LA129Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Okeechobee, FLWhile in cruise flt the plt placed the acft in a dive to avoid what appeared to be the landing light of another acft. The light was actually a space vehicle which had just been launched from cape canaveral air force station 60 miles from the acft's position.…NTSB LAX85FA181Accident · 3 fatalField investigationFinal reportBeech B35D · Mojave, CAThe left stabilizer assembly separated from the acft in-flt. The alt and airspeed at the time of the separation were not determined. Plts of acft flying in the area at about the time of the accident reported moderate to severe turbulenceand up and down drafts…NTSB SEA85LA079Accident · No injuriesLimited investigationFinal reportHughes 269C · Elma, WAJust prior to lift-off a vibration accompanied by lateral rocking occurred. Although the plt brought the power to idle. The helicopter had already started to come apart. During engine examination it was found that the ground resonance occurred due to under to…NTSB CHI85IA143Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Champaign, ILDuring engine start a fuel line running between the fuel pump and the differential pressure switch ruptured and caused a small fire. The crew observed a fire warning light,aborted the start procedure and activated the fire extingui shing system which put the…NTSB ATL85LA120Accident · No injuriesLimited investigationFinal reportCessna 411 · Mobile, ALThe acft experienced a ttl electrical failure for unknown reasons. The plt descended and flew below low ceilings until and arpt was found. Attempts to lower the landing gear with the emerg hand crank failed. Low on fuel, he landed with gear up. The plt…NTSB MKC85LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Anton Chico, NMPilot stated that he was on a VFR no-flight-plan-flight from meade, KS, to alburquerque, NM, when he saw a cloud bank ahead. While diverting around, he flew into haze that became clouds. Recovery from strong down and up drafts did substantial damage to wings,…NTSB NYC85LA074Accident · No injuriesLimited investigationFinal reportAero Commander 680V · Kingstown, RIWhile en route at 12,500 ft, the plt noted a slight shudder & heard a 'wind noise' then the gear unsafe light illuminated. The plt slowed the acft to 135 KTS & tried recycling the gear, but the gear only dropped to the point where it would twist. All attempts…