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 FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…NTSB MKC88DCA01Accident · 1 fatalFinal reportRosenmayer Skyranger S/C · Maryland Hgts, MOWitnesses observed the a/c making a turn when the wings came off and the a/c nose-dived to the ground with the wings 'floating' down after the a/c. examination of the wreckage found a fatigue crack 1/3 the circumference with instantaneous cracking on the…NTSB FTW88IA145Incident · No injuriesIncident investigationFinal reportBell 222UT · Cameron, LAPlt stated that the acft pitched 20 deg nose down without warning while in cruise flt at 1,200' and 120 KTS. Following recovery, the acft required additional rt pedal to stay in trim and it flew about 10 deg nosed down in lvl flt. Flt diverted to the opr's…NTSB SEA88LA143Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · North Bend, ORDrg a logging opn, the plt noted an apparent transmission malfunction. An autorotative landing was made on unprepared terrain & the helicopter was damaged. An investigation revealed the tail rotor drive input gear in the 42 deg gearbox had failed from…NTSB ATL88LA225Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · N. Myrtle Beach, SCThe plt reported that he made a low pass over the banner staging area to drop a banner; the release mechanism in the cockpit failed to operate and the banner remained in tow. Xwind conditions blew the banner into another banner on the ground which was…NTSB FTW88LA142Accident · No injuriesLimited investigationFinal reportBeech A36TC · Vega, TXUnreported propeller strike.NTSB CHI88DER06Accident · No injuriesFinal reportHiller UH-12E · Buffalo Lake, MNWhen the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail…NTSB ANC88FA100Accident · No injuriesField investigationFinal reportFairchild SA227-AT · Anchorage, AKDuring the taxi to the runway, the flight crew noted a vibration in the airplane and stopped to check the tires, thinking that they were underinflated. No obvious problem was seen, and they elected to takeoff. Shortly after takeoff, a fire erupted in the left…NTSB FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…NTSB MKC88LA122Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brinkley, ARDuring the take-off roll for an aerial application operation, the pilot said he lost his left wheel braking capability. He continued the take-off, flew to the farm field to be treated, applied the load, then returned to a near by alternate landing strip…NTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…NTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…NTSB SEA88FA131Accident · 1 fatalField investigationFinal reportApplebay Zuni 2 · Wellington, NVThe plt (with only 13 hrs flt time in the hi performance sailplane) took off at 1330 PDT. Psn rprts with her gnd crew were normal until 1630, then another plt offered to relay messages. After ctcg her gnd crew, the otr plt tried calling her back at aprx 1645,…NTSB CHI88LA166Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-21-G · Elyria, OHNTSB NYC88IA186Incident · No injuriesIncident investigationFinal reportMBB BK-117 · Manhattan, NYFailure of the main rotor blade appears to be the result of a static downward bending overstress, caused by another helicopter hovering over or very close to the main rotor blade as it was in a static/stopped position.NTSB LAX88LA253Accident · No injuriesLimited investigationFinal reportCessna T210L · Bakersfield, CADuring the landing roll, the right brake failed to hold. The airplane veered to the left, off the runway and collided with a runway light. Inspection of the brake revealed that there was no fluid in the system. No leaks were discovered during the exam of the…NTSB ATL88FA213Accident · Serious injuriesField investigationFinal reportBell TH-1L · Walterboro, SCThe military surplus helicopter experienced a 42 degree gear box failure while lifting a load of logs. The helicopter subsequently landed hard as the plt was attempting to autorotate to a ldg. Metallurgical examination of the gearbox revealed that a gear…NTSB CHI88DEP05Accident · No injuriesFinal reportGriffin Pitts S-1S · Rio, WIWhen the pilot of the amateur built biplane initiated a go-around from a VFR approach, he found that he had no response to throttle application. He then executed an intentional forced landing in an adjacent field. During this landing the aircraft collapsed a…NTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…NTSB LAX88FA249Accident · Minor injuriesField investigationFinal reportHughes 269C · Van Nuys, CAFlight with undertorqued rotor dampers.NTSB CHI88IA157Incident · No injuriesIncident investigationFinal reportBeech C99 · Indianapolis, INComponent failure due to improper lubrication by the operators maintenance personnel.NTSB CHI88IA159Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Indianapolis, INFailure to ensure proper alignment and closure of the auxillary power unit lower shroud with the fire seal upon completion of a maintenance action.NTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…NTSB DEN88LA152Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Fort Collins, COThis Balloon flt was part of a rally. The flt departed from a stadium, climbed to 500' and then made a controlled descent and landing. After the next takeoff and climb to about 125' when the burner was turned off the plt noticed that fuel was not flowing to…NTSB LAX88DVD06Accident · Serious injuriesFinal reportLocolce/Blackwell Falcon XP · Antioch, CAWhile entering downwind for landing, the rudder did not respond. The airplane began to yaw to the left at a 30 degree banking spiral turn. The pilot deployed the emergency parachute and the airplane collided with the terrain. Inspection of the airplane…NTSB BFO88IA065Incident · No injuriesIncident investigationFinal reportCessna T210R · Washington, DCImproper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.NTSB LAX88LA247Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-26A · Montague, CADuring a pleasure flight, the last transmission by the pilot stated he was going to see what the glider could do besides straight and level flight. Witnesses in the area reported that they heard a loud pop and observed the glider, minus the left wing, in a…NTSB ATL88FA207Accident · 1 fatalField investigationFinal reportPiper PA-32 · Uniontown, ALNTSB ATL88LA205Accident · No injuriesLimited investigationFinal reportBeech K35 · Greensboro, NCThe flight was climbing to 11,000 feet with an instrument flight clearance when a propeller blade separated from the hub. The blade was subsequently recovered from the yard of a local resident. The fracture examination disclosed that the cracking originated…NTSB FTW88DPJ07Accident · Minor injuriesFinal reportNorthrop C-125A · Tulsa, OKThe pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness…NTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.NTSB MIA88FA201Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Catano, PRAs the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up…NTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…NTSB NYC88FA166Accident · 2 fatalField investigationFinal reportBell 206L-1 · Springtown, PAWhile in cruise flight, ground witnesses observed the helicopter make two violent roll maneuvers followed by an in-flight breakup. Aircraft wreckage was spread over an area of approximately 10 acres. Examination of the wreckage revealed that the collective…NTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.NTSB ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GANTSB FTW88LA121Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Mico, TXThe pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport…NTSB LAX88DUG04Accident · Serious injuriesFinal reportBushby Mustang II · Upland, CADuring a pleasure flight, while flying s turns and lazy eights, the canopy suddenly separated from the airplane. The airplane was landed without further incident. The canopy was not recovered. The reason for the separation was not determined.NTSB ATL88DLQ01Accident · No injuriesFinal reportByron/Sorrell SNS-2 · Morehead, KYInflight separation of both propeller blades from the acft for undetermined reasons.NTSB LAX88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grand Canyon, AZFailure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee…NTSB LAX88LA212Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Lihue, HIFatigue failure of the engine to transmission drive shaft engine coupling due to an angular misalignment of the drive shaft.NTSB LAX88LA211Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lakeport, CADuring a banner tow operation, the plt tried to release the banner. When the banner did not disconnect, the plt turned to see what the problem was. The airplane stalled and before the plt could regain control, it collided with the terrain. Inspection of the…NTSB CHI88IA129Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Madison, WIFailure of the right outboard flap position signalling cable due to chaffing initiated by improper installation/rigging by a manufacturer's vendor.NTSB LAX88FA196Accident · 1 fatalField investigationFinal reportBeech H-35 · Phoenix, AZThe plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the…NTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…NTSB FTW88DRD05Accident · No injuriesFinal reportGrumman G-164B · Bastrop, LAThe plt said he was spreading rice when he noticed the oil pressure was decreasing & the prop was beginning to feather. With no other place to go, he landed in a plowed field. Shortly after touchdown, the acft nosed over to an inverted position. An exam…NTSB ATL88FA186Accident · 1 fatalField investigationFinal reportCessna 402B · West Columbia, SCThe airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,…NTSB CHI88DEC02Accident · 1 fatalFinal reportChappel Ratsrepus 300 · Pontiac, MIDestructive wing/aileron flutter is suspected, but not sufficiently substantiated through research and calculations to be cited as the probable cause of this accident.NTSB MIA88LA175Accident · No injuriesLimited investigationFinal reportGlobe GC1-B · Miami, FLHydraulic motor activated light remained on after landing gear retraction. The pilot believing this to indicate a landing gear malfunction slowed the acft and extended the gear. A gear down indicator illuminated. However, the hydraulic motor activated light…NTSB SEA88LA099Accident · No injuriesLimited investigationFinal reportBrown 1911 Bellanca · Carson City, NVThe purpose of the flight was to test a new type of propeller which had just been installed on the aircraft. The pilot noticed prior to rotation an increase in the RPM. At rotation the nose up pitch was excessive. The pilot lowered the nose of the aircraft to…