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 NYC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172H · Oneonta, NYThe plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…NTSB NYC88LA002Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Newport, VTShortly after takeoff, the eng lost power as the acft was climbing thru about 75' AGL. Subsequently, the acft was damaged during an emerg landing. An exam revealed the acft had a very loosely fitting fuel cap & water was found in the fuel lines & sumps. The…NTSB MKC88LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, ARDuring tkof from a private 1500 foot airstrip the student plt stated that the acft would not climb and began to settle. He realized he was losing airspeed and did not have enough altitude to trade for airspeed so he chopped the throttle and made an emergency…NTSB MKC88LA001Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Wamego, KSDuring a night ldg the plt aligned the acft with the white tops of a fence that was parallel to the runway. Not all of the rwy lights were illuminated. Both wings and the lower fuselage were substantially damaged during the lndg on the fence.NTSB MIA88LA014Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Union Church, MSAt an altitude of aprx 75 feet during an agricultural turn, the plt reported that the engine lost power. While executing a forced landing, the rotor blades contacted trees, after which, during the descent, the right skid collided with a stump & the helicopter…NTSB DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…NTSB ATL88LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Cordesville, SCThe airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…NTSB ATL88IA074Incident · No injuriesIncident investigationFinal reportMooney M-20E · Columbia, SCDuring takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the…NTSB MIA88FA003Accident · 4 fatalField investigationFinal reportCessna 310K · Inverness, FLWitnesses stated that the plt initiated a go around at the runway 19 threshold, broke off to the right & went behind a tree line in a 60 degree right bank. On the other side of the tree line the acft was observed to strike the trees with the left wing and…NTSB LAX88FA006Accident · No injuriesField investigationFinal reportBoeing 767-201 · Los Angeles, CAThe captain sensed the aircraft ballooning during the flare. He increased the pitch angle to 11.8 degrees to arrest the descent during touchdown. Flight attendants sitting in the aft cabin crew seats heard a scraping sound just prior to main landing gear…NTSB DEN88LA010Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMTwo balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally…NTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…NTSB DEN88FA002Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · Fowler, CODuring a pleasure flight the pilot flew too low over the Arkansas river, collided with powerlines and crashed into the river. The pilot stated he could not see well due to the setting sun in his eyes. The pilot and his passenger received serious injuries and…NTSB CHI88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Verona, WIDuring a VFR landing abort full power was applied and flaps selected to the full up position. The aircraft began to settle and a turn to the left was initiated. The left wing dropped abruptly, the nose pitched down and a left hand rotation began. This…NTSB CHI88IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Milwaukee, WIAircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and…NTSB MIA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Church Hill, MSWhile in cruise flight at 1,000 ft, the eng lost power. The plt performed a forced landing in a soft field and during the landing roll, the acft hit a dirt bank, nosed over, and came to rest inverted. Post crash examination of the fuel system revealed that…NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…NTSB LAX88LA004Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Clearlake, CAThe aircraft nosed over when the pilot made a water landing with the wheels extended. The pilot failed to use the landing checklist.NTSB LAX88LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Big Bear City, CAThe student pilot bounced during landing and collided with runway lights and a taxiway sign. He landed on runway 25 with winds reported 040 degrees at 8 knots. He said he could not receive wind information because he had inadvertantly turned off his radio.NTSB LAX88FA001Accident · 1 fatalField investigationFinal reportCessna 172RG · Calistoga, CAUpon arriving over the destination arpt the plt used an incorrect CTAF frequency to contact the arpt and he used a right hand traffic pattern approaching the 2600 foot-long rwy. Because a residential area lay west of the arpt & open fields lay to the east,…NTSB CHI88FA001Accident · No injuriesField investigationFinal reportBeech A35 · Grand Ledge, MIAfter rtrng fm a x-country flt, the plt was about to turn downwind to land when the eng began to lose power. He moved the fuel selector from the left main to the rgt main psn & pumped the wobble pump svrl times, but the eng did not restart. He then moved the…NTSB LAX88LA002Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Carefree, AZDuring the first takeoff attempt, a small portion of the balloon envelope caught fire and was quickly extinguished. The second takeoff attempt was successful. One passenger on the balloon said that the flight was very erratic ranging in altitude from 10 feet…NTSB BFO88IA001Incident · No injuriesIncident investigationFinal reportFokker F-28-MK-1000 · Baltimore, MDThe acft had a main gear only landing after the nose gear failed to lock down. This was the first flight since a newly overhauled nose gear was installed. It was determined that when the nose gear was installed and before it was corrected, a wrong washer was…NTSB ATL88LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Thomson, GADuring the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt…NTSB ATL88LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Grand Bay, ALThe engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide…NTSB ATL88LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Hilton Head, SCThe student plt was performing a crosswind landing which resulted in a hard landing. The acft drifted to the side of the rwy and one wheel was off the paved surface upon the next touchdown. The student plt attempted to hold the acft straight in the direction…NTSB ANC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · 45 Nw Anchorage, AKThe pilot stated that he believed he ran out of fuel during the IFR flight.NTSB NYC88LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Mansfield, MAAccording to the plt, the winds were from the south-southwest at 15 to 20 KTS. He rprtd that drg the landing roll on rwy 22, he applied full right rudder against the prevailing wind, but the acft veered left with the application of brakes. Subsequently, it…NTSB MIA88FA001Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Everglades City, FLThe non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about…NTSB FTW88LA001Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bulverde, TXOn the second approach after a go-around, the aircraft landed approximately halfway down the 2850 ft runway. In an attempt to go around the pilot applied power. The aircraft started to climb but collided with the top of a tree causing the tail of the aircraft…NTSB ANC88LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wind River, AKThe acft lost power during takeoff and the acft stall/mushed back to ground contact. The pilot stated that the partial power failure was due to carburetor icing. The examination of the aircraft engine revealed no mechanical failure or malfunction.NTSB FTW87LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alvin, TXThe plt initiated a soft field type takeoff with 10 deg of flaps. He said that he started the takeoff with 'full aft control wheel' until the acft became airborne, then he lowered the nose to remain in ground effect. However, he failed to maintain airspeed &…NTSB DEN88FA001Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Miles City, MTA cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew…NTSB DEN88DQA01Accident · 2 fatalFinal reportChristen Industries Eagle II · Roswell, NMThe plt and his plt rated pax departed Roswell at about 0900 MDT to practice maneuvers in the local area. The wreckage of the homebuilt acft was found in an open field about 1+20 after takeoff. There were no known witnesses to the accident. The inverted…NTSB DEN87LA248Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Colorado City, COThe plt made several circling approaches before landing. When he did land his acft, he said that he landed fast and long. He applied the brakes but went off the end of the rwy, hit an embankment, and nosed over.NTSB CHI88DEP01Accident · Minor injuriesFinal reportGrumman G-44 · Delevan, WIOn initial takeoff roll the aircraft experienced a loss of control in a strong crosswind, departed the runway to the left, struck a tree line and over turned.NTSB ANC88LA001Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Fairbanks, AKThe plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over.NTSB SEA87LA197Accident · No injuriesLimited investigationFinal reportBeech A100 · Gold Beach, ORShortly after the aircraft touched down on the runway, the right main gear collapsed. Despite the pilot's attempts to correct the situation with left rudder and braking, the aircraft veered to the right of the runway and collided with a building. Shortly…NTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB MKC87LA182Accident · No injuriesLimited investigationFinal reportCessna 150K · Dubuque, IANearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted.NTSB MIA87LA266Accident · Serious injuriesLimited investigationFinal reportAero Commander 720 · 50 Nw San Juan, PRFifteen minutes after a northwest departure from san juan international arpt the plt reported that the flt was returning to land after securing the rt eng due to reported problems. Unable to maintain altitude the acft was ditched aprx 50 miles northwest of…NTSB MIA87LA265Accident · Serious injuriesLimited investigationFinal reportCASA 212-200 · San Juan, PRThe co-plt was helping the passengers de-plane while the plt remained in the acft with the engines winding down after shutdown. The plt stated that he observed a commotion outside the acft and shortly thereafter exited it. He then realized that an individual,…NTSB LAX87FA350Accident · 6 fatalField investigationFinal reportCessna 340A · San Diego, CAAt aprx 0600, the acft depd guerrero negro, Mexico on an air taxi flt to tijuana, Mexico. At 0715, the tijuana wx was rprtd as partially obscured, vis 1 mi with fog, haze & smoke, wind calm. Drg arrival, the plt was clrd for an ILS rwy 9 apch & rprtd over the…NTSB DEN87LA249Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangley, COThe student pilot was on his second supervised solo flight and was attempting a second landing on runway 24. The plt stated that the approach was normal and that the acft bounced on touchdown. The plt attempted to correct and the acft banked left. Power was…NTSB DEN87LA247Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Grand Junction, COThe plt was practicing some helicopter maneuvers in preparation for taking an FAA flt examination. During one of his maneuvers the helicopter's main rotor blades struck the ground causing the acft to crash. A post accident fire errupted and destroyed the…NTSB ATL87LA267Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Mansfield, OHThe plt reported that the helicopter made an uncommanded turn to the right and rolled to the left as she was hover-taxiing away from the hangar toward the takeoff area. The acft subsequently impacted the terrain and came to rest on its left side. Post-crash…NTSB ATL87FA268Accident · 5 fatalField investigationFinal reportBeech 95-B55 · Manteo, NCWitness observed acft settle into ocean during low level cruise flt adjacent to beach. Wx was ovrcst, indistinct horizon & calm sea. IFR flt plan had been filed but no contact was made with ATC. Engines and propeller examination did not reveal a mechanical…NTSB ANC87LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Anchorage, AKThe pilot stated that she departed the airport with only one quarter tank of fuel; on final approach to the runway the engine quit. The owner stated there was less than ten (10) gallons on board the aircraft prior to take off.NTSB NYC87LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, CTThe plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to…NTSB NYC87LA263Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Kingston, NHDuring flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an…