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.

NTSB FTW87LA211Accident · Minor injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe plt was on a x-country flt from addison to College Station, TX, but diverted to livingston, TX, due to 'time constraint.' The arpt at livingston was unattended. At aprx 1615 CDT, he took off & contd to College Station. However, during the flt, he became…Sep 6, 1987 · N48140 · Substantial damageNTSB CHI87LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Perham, MNThe pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed.Sep 6, 1987 · N734GF · Substantial damageNTSB CHI87LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Indianapolis, INThe acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the…Sep 6, 1987 · N9287W · Substantial damageNTSB ATL87LA251Accident · No injuriesLimited investigationFinal reportCessna 172E · Lebanon, OHA witness rprtd the acft was hi & fast on final apch. The plt stated he landed the acft long & fast & was unable to stop on the remaining rwy. Subsequently, the acft impacted a ditch beyond the dep end of the rwy & the nose gear collapsed. Before the acft…Sep 6, 1987 · N3970S · Substantial damageNTSB ATL87LA249Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Enterprise, ALDuring a practice autorotation, the instructor pilot delayed in appling power to arrest the autorotative descent. The other pilot reported that the autorotation profile was was not the same as the previous successful autorotation. There were no reported…Sep 6, 1987 · N38CD · Substantial damageNTSB ANC87LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tanana, AKThe pilot stated that he just lifted off the lake when the engine quit. The aircraft stalled and crashed into the lake. The pilot stated that he just ran out of fuel.Sep 6, 1987 · N4136E · Substantial damageNTSB ANC87LA141Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Talkeetna, AKThe pilot attempted to take off from an unimproved site while the inside of the airplane's windows were partially obscured with condensation. The airplane struck a rock with its main gear during the take off roll and became prematurely airborne. The pilot…Sep 6, 1987 · N8CK · Substantial damageNTSB ANC87LA139Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot stated that after rollout on the grass runway, he lost directional control causing the plane to ground loop. Exmination of the tailwheel revealed that the tire was flat prior to the landing.Sep 6, 1987 · N93018 · Substantial damageNTSB ANC87FA146Accident · 2 fatalField investigationFinal reportCessna U206E · Harding Glacier, AKThe private pilot and his non-pilot adult male passenger were flying from modesto, CA, to soldotna, AK, for a hunting trip. The pilot, who had approximately 164 hours total flight time at the time of the accident, and who had no prior flying experience in…Sep 6, 1987 · N9407G · Substantial damageNTSB ANC87FA138Accident · Serious injuriesField investigationFinal reportCessna 175A · Anchorage, AKThe acft contacted a row of trees and crashed in a residential area shortly after takeoff. The pilot reported, that a downdraft was encountered after establishing a positive rate of climb on takeoff. Airspeed decreased when the downdraft was encountered and…Sep 6, 1987 · N6921E · Substantial damageNTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.Sep 5, 1987 · N2467F · Substantial damageNTSB SEA87LA181Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Burbank, WAWhile on a local pleasure flight the pilot made a 30 degree, banked turn at reduced power. The aircraft entered a stall and descended to the ground. The aircraft has no stall warning system.Sep 5, 1987 · N71513 · DestroyedNTSB NYC87LA246Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Harrisburg, PAThe aircraft engine lost power while descending for a landing. The plt stated that when he advanced the throttle the engine quit completely. During lndg alongside a turnpike, the nose wheel collapsed and the prop was damaged. Investigation revealed that the…Sep 5, 1987 · N3023M · Substantial damageNTSB LAX87LA324Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lee Vining, CAWhile flying over mountainous terrain. The pilot inadvertently followed the wrong road & went into a box canyon area. He stated the visibility was about 5 miles & he did not see the upcoming rising elevation. Eventually, he got into a situation were the acft…Sep 5, 1987 · N6122G · DestroyedNTSB FTW87FA210Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Graford, TXThe pilot departed possum kingdom airport and entered a crosswind turn. The pilot heard a loud 'pop' and could not move the aileron control to recover from the turn. The aircraft entered an uncontrolled descent and crashed into a lake. The aileron pulley for…Sep 5, 1987 · N68529 · Substantial damageNTSB FTW87FA209Accident · 1 fatalField investigationFinal reportMooney M-20C · Waller, TXIt was reported that a private pilot was receiving instrument flight instructions from a CFI when the accident occurred. However, the CFI stated that he was invited by the pvt plt to go with him on a short flight and that he was only a passenger. During the…Sep 5, 1987 · N5590Q · DestroyedNTSB FTW87FA208Accident · Minor injuriesField investigationFinal reportCessna 208 · Bulverde, TXAfter leveling at 5500', the standby power annunciator light illuminated, followed by loss of oil pressure. The plt turned back toward the arpt, but there was a progressive loss of eng power & the prop went to a feathered psn. Drg an emerg landing at night,…Sep 5, 1987 · N807LA · Substantial damageNTSB DEN87LA236Accident · No injuriesLimited investigationFinal reportLet L-13 · Buena Vista, COThe plt was ferrying the glider to Buena Vista, Colorado & had previously obtained permission to land on a closed rwy. After being towed to the Buena Vista area, he released the glider from the tow plane & flew in the local area for about 40 min. He then…Sep 5, 1987 · N38924 · Substantial damageNTSB DEN87LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-210 · Yuma, COThe plt said that during his final approach for landing he thought his airspeed was too high for touchdown and he attempted to go around. During the go around his acft struck an arpt sign and a bldg.Sep 5, 1987 · N2171P · DestroyedNTSB DEN87LA232Accident · No injuriesLimited investigationFinal reportNational Balloon 858 · Colorado Spring, COThe commercial balloon plt was competing in a balloon race. While landing, with the basket on the ground, the balloon drifted into power lines. A large hole was burned in the envelope, and the basket was damaged. The plt and two passengers jumped from the…Sep 5, 1987 · N32201 · Substantial damageNTSB CHI87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILThe accident occurred on a local training flight. At 3500 ft MSL the eng failed. The student plt landed at a near-by arpt but bounced on touchdown, veered off the rnwy and nosed over. Eng exam disclosed broken primary venturi in carb.Sep 5, 1987 · N67447 · Substantial damageNTSB BFO87FA062Accident · 2 fatalField investigationFinal reportCessna 172P · Cabin, WVThe plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to…Sep 5, 1987 · N65721 · DestroyedNTSB ANC87LA151Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Salcha, AKThe private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind…Sep 5, 1987 · N4183Y · Substantial damageNTSB ANC87LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Mcgrath, AKA local hunting guide crashed his airplane in a remote mountain pass in central Alaska. Another guide who overflew the crash site shortly after the accident saw the airplane burning, but was unable to land due to strong winds, severe turbulence and strong…Sep 5, 1987 · N4191Z · DestroyedNTSB ANC87FA140Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Coal Lake, AKThe pilot of the airplane stated that he had step-taxied to the east end of the Lake in preparation for a takeoff to the west. During the take off run, the airplane struck the wake he had just created and became prematurely airborne. He reduced power in an…Sep 5, 1987 · N39450 · DestroyedNTSB ANC87FA137Accident · 1 fatalField investigationFinal reportEnstrom F-28F · Anchorage, AKThe pilot of the helicopter was seen flying at approximately 50 feet AGL down the length of a private gravel airstrip near Anchorage, Alaska. A nearby jogger said that the pilot appeared to wave at him as he flew past and then he heard the helicopter crash…Sep 5, 1987 · N8622A · Substantial damageNTSB MIA87LA240Accident · No injuriesLimited investigationFinal reportBell 47G · New Port Richey, FLThe plt was practicing an autorotative lndg for a planned CFI checkride. Drg the lndg, the helicopter touched down on the aft portion of the skids, then pitched forward. As it pitched forward, the plt applied full aft cyclic & the main rotor blades contacted…Sep 4, 1987 · N73DB · Substantial damageNTSB DEN87FA230Accident · 1 fatalField investigationFinal reportCessna 170B · Cedar City, UTWhile on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon.Sep 4, 1987 · N3541D · DestroyedNTSB DEN87DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Center, COThe plt reported that the eng lost power while the acft was en route to spray a field. There was no suitable terrain for a forced landing and the plt landed the aircraft in a soft, cultivated field and nosed over. Examination of the eng revealed burned and…Sep 4, 1987 · N6796Z · DestroyedNTSB ATL87FA248Accident · 1 fatalField investigationFinal reportCessna 182 · Lima, OHDuring a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…Sep 4, 1987 · N71536 · DestroyedNTSB ATL87DEI12Accident · No injuriesFinal reportTomishin W-8 · Painesville, OHThe plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the…Sep 4, 1987 · N3992A · Substantial damageNTSB NYC87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Montgomeryville, PAWhile climbing through about 1500' after takeoff, the engine began to lose power. The pilot turned back toward the airport, but subsequently all power was lost & the aircraft was damaged during a landing in a corn field. A post- accident examination revealed…Sep 3, 1987 · N596SP · Substantial damageNTSB MKC87LA170Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Springdale, ARThe plt rprtd that shortly after takeoff, the eng lost power, recovered for a few seconds, then went to idle. Drg the few seconds that power was restored, he initiated a turn back toward the rwy. The plt said the acft started to snap roll to the left & went…Sep 3, 1987 · N3761Q · Substantial damageNTSB LAX87LA323Accident · No injuriesLimited investigationFinal reportCessna 140 · Gorman, CAA Cessna 140 nosed over during the landing roll after a precautionary landing to a paved access road. The plt indicated that the oil pressure and oil temp began to drop for unknown reasons while in cruise flt. The plt stated he was unable to determine the…Sep 3, 1987 · N224MK · Substantial damageNTSB FTW87LA207Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Livingston, TXDrg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with…Sep 3, 1987 · N894B · Substantial damageNTSB CHI87LA207Accident · No injuriesLimited investigationFinal reportCessna 150L · Ludington, MIDrg the takeoff roll, the acft went off the left side of the rwy. The student rprtd the takeoff roll seemed normal untilrotation, but when the nose wheel lifted off the rwy, the acft began to veer to the left. He stated he was unable to correct the situation…Sep 3, 1987 · N7502G · Substantial damageNTSB CHI87IA201Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-71 · Chicago, ILSmoke detected in the cabin resulted in an evacuation of the aircraft just after being pushed back from the jet-way. Subsequent investigation established that a malfunctioning pack valve had caused the air-conditioning system to overheat causing the smoke.…Sep 3, 1987 · N8078U · No damageNTSB CHI87FA212Accident · No injuriesField investigationFinal reportCessna 177 · Genoa, ILThe plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…Sep 3, 1987 · N2295Y · Substantial damageNTSB BFO87LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Tappahannock, VAThe acft was at 1500 MSL when a 300 RPM loss of power occurred. The plt sighted a private landing strip and he decided to make a precautionary landing on it. During the landing roll on the 62 ft wide grass strip the l wing struck corn stalks in an adjacent…Sep 3, 1987 · N78505 · Substantial damageNTSB ATL87DLT04Accident · No injuriesFinal reportNord SV4C · Lebanon, TNThe pilot stated while on final approach he allowed the aircraft to get too low and slow. He realized it was too late to recover and the aircraft collided with a tree.Sep 3, 1987 · N125V · Substantial damageNTSB ATL87DKG06Accident · 1 fatalFinal reportPitts S-1 · Brooks, GAThe acft was observed in aerobatic maneuvers near the departure airfield. The last of the series was a lomcevak maneuver, which was started at an estimated alt of 2500 to 2700 ft. a witness rprtd the acft went into an inverted flat spin, which was corrected…Sep 3, 1987 · N11HJ · DestroyedNTSB ANC87LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong…Sep 3, 1987 · N4451M · Substantial damageNTSB SEA87FA180Accident · 1 fatalField investigationFinal reportCessna U206G II · Yakutat, AKAcft was observed to depart from controlled flight while in a steep left turn at slow speed and low altitude, impacting on a river sand bar. Fire ensued, demolishing acft. Following heavy rains, river rose and acft not recovered.Sep 2, 1987 · N756PS · DestroyedNTSB NYC87IA258Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Portland, METhe acft was cruising at 2500 ft with no passengers on board. The co-pilot went into the cabin and noticed a loud hissing noise around the main cabin door. He checked the handle and locking pins and noticed the door was locked. He told the captain who…Sep 2, 1987 · N204BH · No damageNTSB MIA87LA238Accident · No injuriesLimited investigationFinal reportAero Commander 680FL · St ThomasAfter a loss of hyd pressure, the rgt main gear would not fully extd when the plt tried to lower the gear for lndg. All atmts to lock it into place were unsuccessful. When the acft touched down drg the lndg, the rgt main gear collapsed. The acft slid to a…Sep 2, 1987 · N111UA · Substantial damageNTSB MIA87IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLDuring descent the B727 crew noted the fire warning light illuminate on the #1 engine. They discharged 2 fire bottles into the engine but the warning light remained illuminated. They declared an emergency and landed at their destination. An emergency…Sep 2, 1987 · N844AA · Minor damageNTSB MIA87FA239Accident · 1 fatalField investigationFinal reportCessna 421 · Coral Springs, FLThe acft had been abandoned in the Bahamas for aprx 7 months. A plt, with no known flt time in a Cessna 421, flew it to ft lauderdale. Except to avoid clds, he made the flt at a low alt & airspeed. When asked why, he said he was trying to save the engs. The…Sep 2, 1987 · N421DT · DestroyedNTSB LAX87LA322Accident · No injuriesLimited investigationFinal reportGovernment Aircraft Fact Nomad 24A · Lanai, HIWhen the flt was aprx 15 mi west of Lanai on a cargo flt from honolulu to hilo, HI, the plt observed the fuel gauges oscillating erratically toward the low side. He diverted toward Lanai to refuel. However, when the flt was abt 9 mi westof Lanai, the left eng…Sep 2, 1987 · N37808 · Substantial damageNTSB LAX87LA321Accident · No injuriesLimited investigationFinal reportCessna 152C · Upland, CAThe dual instruction flight completed 2 full stop landings on runway 06 at the cable airport. On the next takeoff the flight encountered a downdraft after turning on the crosswind leg. The instructor pilot took the controls and turned to the downwind leg but…Sep 2, 1987 · N757HK · Substantial damageNTSB CHI87LA200Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Appleton, WIThe plt rprtd that after the acft was at cruise flt, there was a rapid loss of hydraulic pressure. He returned to the dep arpt, but was unable to get the left main gear to lock down. Subsequently, the left main gear collapsed when the acft was landed. An…Sep 2, 1987 · N9168N · Substantial damage