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 NYC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Falmouth, MAAbout 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…NTSB SEA87LA092Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315-D Lama · Siletz, ORDuring external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the…NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB NYC87LA142Accident · Serious injuriesLimited investigationFinal reportPik 20 · Julian, PAThe glider was assembled and all controls checked for freedom of movement prior to takeoff. During initial takeoff and climb, while in tow, the acft pitched nose up abruptly breaking the tow rope. The acft was then observed to turn right and nose down into…NTSB LAX87DVG06Accident · Minor injuriesFinal reportAyres S-2R · Williams, CAThe plt reported he heard something break. The sound was followed by a vibration. The plt then turned to land on a road. He was unable to maintain alt and airspeed. The rockwell S2R landed in a cultivated field and nosed over after a collision with a dirt…NTSB MIA87LA156Accident · No injuriesLimited investigationFinal reportDouglas DC-6A · Ft.Lauderdale, FLThe plt stated that they had made a normal landing and on rollout experienced severe vibration from a nose wheel shimmy. The vibration resulted in substantial damage to the horizontal stabilizer spar attach points.NTSB CHI87LA120Accident · No injuriesLimited investigationFinal reportCessna 150J · Detroit, MIWhile on approach to Detroit city airport the #1 cylinder fractured and separated resulting in engine failure. The pilot made a forced landing in a field approx. four miles west of the airport. Examination of the broken cylinder revealed the mode of the…NTSB LAX87LA199Accident · 2 fatalLimited investigationFinal reportHughes 369D · TamuningsA Hughes 369D, operated off of a fishing vessel, went out of control and crashed in the pacific ocean, nr guam. The accident was witnessed by the ship's captain. His statement indicated one of the main rotor blades separated in flt while the helo was orbiting…NTSB SEA87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ritter Butte, ORDuring a cross country flt the plt noticed that he was gradually losing his communications radio and navigational instruments. Shortly afterwards the plt noticed that the fuel gauges were quickly approaching empty. Since hostile terrain was ahead the plt…NTSB NYC87LA132Accident · No injuriesLimited investigationFinal reportDornier DO-228-201 · Manchester, NHVibration was experienced shortly after touchdown caused by the failure of the propeller blade as a result of fatigue cracking which was initiated from a linear area in a defect free portion of the camber face of the blade. Propagation was through 60% of the…NTSB ATL87LA119Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Clarksville, TNThe pilot lost tail rotor control in cruise flight after the tail rotor drive shaft separated. The tail rotor system had sustained previous damage about 4 years prior to this accident when, while being operated as a public use aircraft, the helicopter skidded…NTSB LAX87LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Catalina, CAJust after takeoff, the plt stated that he heard a loud bang. The acft began to vibrate severely with the engine developing partial power. The acft would not climb and the plt was able to maintain 100 fpm descent. Unable to return to the arpt, the plt ditched…NTSB ATL87LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Waverly, TNThe plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…NTSB SEA87IA084Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Las Vegas, NVAprx 422 flt hrs bfr the flt, the smith Aerostar 601P was modified iaw machen STC SA980NW. Drg level off at 16,500' MSL,blistering & discoloration were noted on the #1 eng nacelle. The plt shut down & feathered the #1 eng, then returned to the departure arpt…NTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…NTSB FTW87FA096Accident · 2 fatalField investigationFinal reportBell 222 · Ben Wheeler, TXAll six lower studs on drive hub assembly failed due to fatique. This disconnected all cyclic and collective controls. Tail boom then separated due to severe vibrations. Helicopter then collided with ground and was destroyed by post crash fire. The plts flt…NTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…NTSB LAX87FA173Accident · Serious injuriesField investigationFinal reportHughes 369E · Palm Desert, CAThe helicopter dscndd uncontrolled & crashed in a residential area. After the acdnt, the plt said he agreed to orbit the residence of his pax. At the aprx 135 deg point of a left orbit, he felt 'a bang & severe vibration in the tail.' The plt lost drctnl ctl…NTSB LAX87DJA05Accident · Serious injuriesFinal reportNihon YS-11A · Honolulu, HIDuring the takeoff ground run approaching V1/VR, the #1 engine fire warning light illuminated and the fire bell sounded. The takeoff was aborted and the acft was turned off the rwy onto a taxiway. The engines were shutdown and the captain ordered a right side…NTSB SEA87LA128Accident · No injuriesLimited investigationFinal reportMooney M20F · Grants Pass, ORShortly after takeoff the pilot realized that he had no airspeed indication due to his forgetting to remove the pitot cover during preflight. The pilot returned to land at the airport and landed gear up.NTSB MIA87LA126Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Miami, FLDuring climb to cruise the pilot lost one blade of the three bladed right propeller, due to the failure of the hub. Examination of the propeller and engine revealed that the crankshaft counterweight bushings were not installed allowing a high frequency…NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB FTW87FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Marlin, TXThe acft had been involved in pipeline patrol throughout its history of 7490 flt hrs. Just before the acdnt, the acft was observed in straight & lvl flt along a pipeline right-of-way. According to witnesses, the acft was at low alt when a wing separated & the…NTSB FTW87DQG01Accident · No injuriesFinal reportReplica P51 · Midland, TXPilot reported prop surging in flt. During landing roll the pilot lost control, groundlooped and the main landing gear collapsed. Investigation could not reveal a reason for the prop surging.NTSB SEA87IA068Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Tuba City, AZWhile engaged in cruise on a scheduled transcontinental flight from new york to los angeles, several stage 1 high pressure turbine rotor blades within the #1 engine separated without warning from their platforms. The initial separation was found to have…NTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…NTSB NYC87FA114Accident · 2 fatalField investigationFinal reportBell 47G · Wassaic, NYThe Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No…NTSB MIA87LA103Accident · No injuriesLimited investigationFinal reportCessna TR182 · No.Atlantic Oc (Atlantic Ocean)The plt departed Canada on a north atlantic ferry flight to shannon ireland after jump starting the aircraft because he left the master switch on overnight. About 750 miles west of the irish coast the electical system failed and he could not transfer fuel…NTSB ATL87IA083Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF340A · Covington, KYAfter a hydraulic sys malfunction, the capt returned to arpt to exchange acft. Company plt had completed day of flying and was asked to taxi acft to maint hangar. Departing capt was in process of manually pumping hyd sys to sufficient pressure to ensure…NTSB NYC87IA105Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Baltimore, MDMain landing gear upper torque link attach bolt separated during takeoff as a result of preexisting stress corrosion cracking. McDonnell-douglas issued alert MD-80 service bulletin A32-220 following the incident.NTSB DEN87LA062Accident · No injuriesLimited investigationFinal reportBeech 58 · Bismarck, NDThe plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…NTSB FTW87DRA01Accident · Minor injuriesFinal reportStrissel Pitts S1S · Friendswood, TXThe prop separated during flt and the plt was forced to land the acft on rough terrain. Investigation revealed that the prop had separated as a result of a previously existing crack in the eng crankshaft. The eng had been rebuilt from components salvaged from…NTSB LAX87LA154Accident · No injuriesLimited investigationFinal reportCessna 190 · Chino, CAPrior to takeoff the pilot observed an asymmetrical deflection of the rudder/brake pedals. Upon landing he executed a right turn to depart the runway. The pilot stated that he was unable to stop the right turn and the aircraft ground looped damaging the left…NTSB LAX87FA119Accident · 2 fatalField investigationFinal reportCessna 441 · Flagstaff, AZThe acft was on an emerg med svc (ems/med-evac) flt with a plt & flt nurse aboard to transport a maternity patient fm Flagstaff to phoenix. Drg a ngt arrival, the plt bgn a vor-a apch in IMC, then he rprtd a problem with his avionics & elected to make a…NTSB LAX87LA123Accident · No injuriesLimited investigationFinal reportCessna 182G · Vallecito, CAA Cessna 182G collided with the rwy surface after the nose gear collapsed at a private airstrip. The pilot indicated that the nose gear turned 90 degrees during the landing roll then collapsed. Pilot examined the nose gear after the accident and discovered…NTSB LAX87FA112Accident · 1 fatalField investigationFinal reportHughes 369D · Honolulu, HIDrg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…NTSB ANC87FA031Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe pilot-in-command accomplished unauthorized repairs to his airplane after an incident four days earlier. He repaired the right main landing gear by using a common door hinge to attach it to the fuselage. Upon landing, the door hinge failed and control of…NTSB FTW87FA054Accident · Serious injuriesField investigationFinal reportPiper PA-22-135 · Floresville, TXThe pilot heard a sudden change in engine sounds during flight and realized his muffler had failed. He was flying about 1000 feet above ground level and initiated a descent to 250 feet. Heat and flames started entering the cockpit through the cabin heat inlet…NTSB MIA87IA081Incident · No injuriesIncident investigationFinal reportEnstrom F28C · Boca Raton, FLThe helicopter spun uncontrollably on the ground after the right anti-torque pedal cable was severed while landing. Examination of the helicopter revealed that the teter stop failed to limit the travel of the tail rotor spindle assy thereby reducing the…NTSB ATL87IA067Incident · No injuriesIncident investigationFinal reportBurkhart Grob G103 Twin Astir · Williamson, GAAs the glider plt was apchg the entry point for landing, he checked the spoilers for operation. The spoilers extended, but would not retract. There was a significant increase in the sink rate & the plt realized he would be unable to reach the arpt.…NTSB CHI87FA069Accident · 1 fatalField investigationFinal reportCessna 210N · Bedford Park, ILJust bfr tkof fm rwy 22L on a ngt IFR flt, the plt was clrd to clb & maint 2000' & to contact chicago dep ctl (TRACON). About 1 min later, he called TRACON & rprtd he was clbg thru 900' for 2000'. This call was in a normal tone of voice & was the last…NTSB MIA87IA078Incident · No injuriesIncident investigationFinal reportBritish BAC 1-11 201 · Orlando, FLAfter landing the auxiliary power unit was started and the number one engine was shutdown. The aircraft then began to pressurize and fill with smoke. An emergency evacuation was ordered by the captain through L-1 and R-1 doors. The slide at R-1 did not work…NTSB CHI87IA067Incident · No injuriesIncident investigationFinal reportBoeing 727-122 · Fort Wayne, INAircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft…NTSB CHI87DEP01Accident · Minor injuriesFinal reportChampion 7ECA · La Crosse, WIAfter the third try at an engine start the eng started and ran at full throttle. The plt could not reduce RPM. To avoid striking two parked acft the plt struck a hangar. Post accident investigation revealed that the throttle cable was not operating properly.…NTSB MKC87LA040Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Corning, IAThe flt had progressed normally from champagne, IL. The IFR flt plan was cancelled at lamoni VOR and the flt proceeded VFR. On final approach to rwy 17, aprx 1 mile from the rwy, the altimeter suddenly unwound and the acft struck trees. The altimeter had…NTSB LAX87FA088Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Oceano, CAShortly after takeoff, the surviving pax (s/p) noticed the acft began losing alt. She heard the plt comment about a 'clicking noise in the left wing' which she also heard & said sounded like metal clicking together. Ground witnesses noticed a change in eng…NTSB NYC87LA058Accident · Minor injuriesLimited investigationFinal reportAgusta A109AII · So. Dartmouth, MAAgusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated…NTSB MIA87LA073Accident · No injuriesLimited investigationFinal reportCessna 310J · Straights Of Fl, FLThe plt stated that the flt departed grand caymen, on January 12, 1987, at aprx 1600 EST. Aprx 3 hrs into the flt the c.h.t & exhaust temperatures hit red line on the left eng following a loss of oil pressure. He secured the eng & then noticed fuel being…NTSB CHI87IA061Incident · No injuriesIncident investigationFinal reportNihon YS-11A-500 · Remmington, INThe flight crew failed to adhere to appropriate procedures and directives when they failed to select the HP cock levers to the hswl (lock out) position while performing an approach to landing stall during a training/test flight. When stall recovery was…NTSB NYC87DHD02Accident · Serious injuriesFinal reportCessna 170 · Pittman, NJThe pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral…