NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 LAX87LA197Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingtonbeach, CAOn touchdown the plt reported that the acft bounced twice. The plt initiated a go-around by retracting the flaps and adding full power. The acft did not gain enough altitude before colliding with a quonset hut located 210 feet from the end of the runway.NTSB LAX87DJA06Accident · Serious injuriesFinal reportSchweizer SGS2-33 · Mokuleia, HIDuring a local sightseeing flt along a ridge line, while maneuvering around a cloud build-up, the acft entered a windshear that suddenly nosed the acft over in an aprx 75 deg vertical dive. Just prior to colliding with trees, the plt was able to regain some…NTSB FTW87LA109Accident · No injuriesLimited investigationFinal reportCessna 172G · Houston, TXA student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his…NTSB FTW87LA101Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · De Quincy, LAThe pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…NTSB ATL87FA123Accident · 2 fatalField investigationFinal reportSwearingen SA-226TC · Wilmington, NCThe right engine failed during takeoff immediately after rotation 3000' down the 7,002' rwy 16. The plt continued the flt and the landing gear remained extended. The unauthorized plt rated pax made xmissions to the tower. Witnesses rpted that the acft reached…NTSB SEA87LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Twin Falls, IDDuring descent from cruise for landing the engine momentarily ran rough and then quit. The pilot attempted to land onto a road but struck a telephone pole in flight. The aircraft then descended onto the ground nose first. No reason for the engine failure…NTSB NYC87LA168Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sanford, METhe acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…NTSB MKC87FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ogden, IAThe airplane was equipped for IFR flight. The pilot was not instrument rated. The pilot had been briefed earlier that VFR flight was not recommended. The pilot did not update the weather for this flight. The front of the airplane was buried seven feet in the…NTSB MIA87LA142Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Dundee, MSThe plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…NTSB LAX87LA192Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Novato, CAThe plt aborted the takeoff attempt before becoming airborne at a point near midfield on the 3360 ft rwy. He rptd smoke in the cockpit from an electrical short of unrptd origin. Both the plt and the plt-rated pax thought they would be able to stop on the…NTSB LAX87LA188Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Temecula, CADuring an aerial survey flight, while on final approach to the arpt, the engine began running rough then quit. The plt was unable to land the acft at the arpt, therefore, a nearby dirt road was selected. During the landing roll the acft collided with the…NTSB ATL87FA122Accident · 1 fatalField investigationFinal reportBeech D-55 · Leesburg, GADuring a return flight at night, the aircraft crashed in an open field. The aircraft impacted the ground in a nose low attitude. The impact displaced the wing assembly rearward perpendicularly through the rear spar assembly. Both engine and propeller…NTSB ATL87DKG01Accident · Serious injuriesFinal reportAir Tractor AT301 · Atmore, ALDuring landing the aircraft collided with a tractor mowing grass on the runway. The pilot stated that the sunglare on final prevented him from seeing the vehicle on the runway. The tractor's operator apparently did not hear the aircraft because he made no…NTSB ATL87DEI02Accident · No injuriesFinal reportBell B-206-1 · Youngstown, OHWhile hovering from the wash rack, the helicopter backed into a utility pole. The main rotor system separated from the airframe following the collision. There were no postimpact mechanical malfunctions/failures.NTSB ATL87DEG04Accident · Minor injuriesFinal reportMclane Moni · Hillsboro, OHAft tkof fm the 3520 foot rwy, the plt stated that at abt midpoint with approx 1700 ft of rwy remaining, the eng sputtered and stopped. He was able to restart it again but aft several seconds it stopped again and he could not restart it. The plt then devoted…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 MKC87LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · West Memphis, ARThe acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found…NTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…NTSB DEN87LA109Accident · No injuriesLimited investigationFinal reportCessna 150J · Longmont, COA student plt was practicing landings on her second supervised solo training flt. On the first approach, she failed to flare properly and hit in a three point attitude. The nose gear collapsed and the propeller struck the rwy. The acft skidded about 25 feet…NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…NTSB DEN87FA110Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Craig, COThe plt and his wife were on a cross country flt to visit relatives in north carolina. Several witnesses observed the aircraft depart Craig-moffet airport with the engine(s) running rough and using almost the entire runway to get airborne. Once airborne the…NTSB BFO87FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Salisbury, MDOn a flt from hilton head, SC to woodstown, NJ, the plt enctrd headwinds & diverted to Salisbury, MD, a less distant arpt. Drg arrival at 1944, he was provided wx info concerning a low ceiling & visibility. At 1955, he was instructed to hold upon reaching a…NTSB ATL87LA121Accident · No injuriesLimited investigationFinal reportBell UH-1B · Bay Minette, ALDuring a logging operation, the helicopter experienced a complete engine failure shortly after attempting a pickup. The pilot entered an autorotative glide. The helicopter impacted the water and sank. The wreckage examination disclosed that the compressor…NTSB ATL87LA120Accident · No injuriesLimited investigationFinal reportCessna R182 · Owensboro, KYPlt in cruise flt at 5500 ft about 30 min after dep fm paducah when he noted a small amount of black smoke coming from top of panel. The rear seat pax noted flames in the panel at the same time. The plt noted his position in relation to Owensboro and…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 ATL87LA118Accident · Minor injuriesLimited investigationFinal reportBeech A23-19 · Huron, OHSoon after takeoff the aircraft experienced a loss of power and made a forced landing 200 feet short of the runway. The pilot reported a loss of fuel pressure. The FAA reported that the fuel aboard the aircraft had the smell and appearance of auto fuel. The…NTSB NYC87LA129Accident · No injuriesLimited investigationFinal reportBell 47G · Bethel, PAThe student pilot lost directional control of the helicopter and as the instructor pilot attempted to regain control, the main rotor blades struck the ground causing substantial damage to the aircraft.NTSB MKC87LA084Accident · No injuriesLimited investigationFinal reportThorp T-18 · Bowling Green, MOThe PIC rptdly encountered a gust of wind during the landing flare. The PIC lost control as one main landing gear impacted the ground abruptly and his head hit the side of the canopy. The acft veered off the side of the rwy into tall grass and soft terrain.…NTSB MKC87FA085Accident · 2 fatalField investigationFinal reportCessna 152 · Marion, IAThe CFI and stu were practicing approaches to the Marion, Iowa arpt. Several witnesses stated that the t & g lndgs were unusual which gained their attn. On the last appch the acft was observed to be slow during the unusually steep appch. Abt 15 to 20 ft AGL…NTSB MIA87IA141Incident · No injuriesIncident investigationFinal reportBell 222U · Oxford, MSThe pilot executed a precautionary landing after hearing a loud bang and experiencing a loss of the number 1 engine. Post accident examination revealed that the power turbine wheel blades had failed, and the wheel parts logjammed and penetrated the engine…NTSB LAX87LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Hawthorne, CADuring a solo instructional flight, the student pilot was practicing touch and go landings. He noticed as the flight progressed, that there was some gusting conditions aloft and that the wind direction was varying. On the last landing the aircraft touched…NTSB LAX87LA186Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lower Lake, CAA Cessna 310Q overran rwy 30 and collided with terrain off the departure end. A witness stated the acft landed at aprx mid-field on the 2,485 ft by 50 ft asphalt rwy and was unable to stop. Based on the witnesses' statement aprx 1,240 ft would be available…NTSB LAX87LA185Accident · Minor injuriesLimited investigationFinal reportCessna P210N II · Tucson, AZA C-172 collided with a C-210N while txg. The C-172 was txg along a 75 ft wide parallel twy after landing. The C-210N was txg from a ramp area to his dep rwy. The C-210N route intersected the C-172 route at the parallel twy where the collision occurred. Plts…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 DEN87LA106Accident · Minor injuriesLimited investigationFinal reportShort Brothers SC7 · Denver, COThe plt said that he made a normal crosswind landing on rwy 26L at stapleton international arpt, Denver, Colorado. After leaving the rwy and taxiing parallel to the rwy he observed the wind increasing in velocity. He stopped the acft but a strong gust of wind…NTSB DEN87LA105Accident · No injuriesLimited investigationFinal reportCessna TR182 · Santa Rosa, NMAn a & p acft mechanic who additionally was a commercial plt was operating a borrowed acft on a local flt. He landed on an island in a lake and shut down. Later, when airborne on takeoff, the right elevator struck a small tree and the acft yawed right. The…NTSB CHI87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Byron Center, MIThe plt stated that following a preflight inspection and engine run-up, he attempted a soft field takeoff on the 2070 foot turf rwy. According to the plt, he aborted the takeoff aprx 1035 feet down the rwy because he held the nose too high and he was dragging…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 SEA87LA082Accident · Minor injuriesLimited investigationFinal reportBell 206-BIII · Kent, WADuring takeoff to a hover the helicopter rolled to the left. The student pilot over corrected. The helicopters right skid contacted the ground with the student pilot making a rapid increase in collective rate causing the helicopter to roll to the right onto…NTSB NYC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lehighton, PADuring takeoff roll, the flight encountered a wind gust and the plt aborted the takeoff at about 1500 feet from the takeoff point. The acft continued to slide off the end of the runway, down a slope and across a road impacting two trees.NTSB MKC87FA083Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Stillwell, KSThe pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…NTSB MIA87LA140Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe plt stated that after landing he allowed the coplt to taxi the acft though he followed him through on the controls due to his lack of experience on tailwheel acft. The acft veered off the left side of the rwy and before control could be re-established by…NTSB MIA87LA139Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot experienced an engine failure in flight and landed the aircraft in a pasture. He then restarted the engine and took off, after take off the engine failed two times and he restarted it. The engine failed the third time and he could not start…NTSB MIA87LA138Accident · Serious injuriesLimited investigationFinal reportCremer VP-1 · Tupelo, MSAcft lost engine power on short final approach. Acft stalled and touched down hard short of the runway. The acft then collided with the raised edge of the runway collapsing the main gear and then nosing over. The pilot attributed the loss of engine power to a…NTSB LAX87LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAWhile making practice landings, the student pilot failed to maintain flying speed during the final stages of his second approach. The aircraft stalled inadvertently about 15 feet above the runway and landed hard on the nose wheel.NTSB LAX87LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lincoln, CAThe aircraft collided with a ditch after a loss of pwr during t/o climb at aprx 350 to 400 ft AGL. The plt described the loss of pwr as 'like taking the throttle and pulling off in a rapid motion.' He noticed during his preflt check that the fuel in the right…NTSB CHI87DET03Accident · Serious injuriesFinal reportJagger Tierra II · Columbia City, INShortly after takeoff at about 100 feet AGL the engine lost power. The aircraft stalled and impacted the ground in a plowed area adjacent to the runway. The owner/pilot stated that an unidentified substance almost totally blocked the fuel filter closest to…NTSB CHI87DEM06Accident · Serious injuriesFinal reportNavion A · Baldwin, MIAfter beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the…NTSB NYC87FA127Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · York, PAThe Piper PA-28-180 was making an NDB instrument approach under instrument meteorological conditions at night. The pilot manuevered the aircraft over the airport several times in an apparent attempt to acquire visual contact with the runway, lost control of…NTSB MIA87LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe plt elected to land the acft on a taxiway after the eng quit aprx 5 miles from the arpt. During the flare, the wing stalled, followed by a hard landing on the nose gear causing it to collapse. Post crash examination of the acft revealed that the eng quit…