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 DEN87FA237Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Pinedale, WYThe plt and two passengers had flown to Pinedale to fish. The plt stated that he was cruising at an alt of 400 ft AGL and was executing a rt turn at the request of a pax. He stated that he slowed the acft, decreased the collective, and added rt pedal as he…NTSB ATL87LA258Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Fremont, OHThe eng lost pwr shortly after tkof. A forced lndg was made in a field where the acft impacted a ditch. Post-crash exam of the acft engine revealed water and solid contamination in the fuel injector servo. The plt had recently purchased the acft. The acft…NTSB SEA87LA186Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Quincy, WADuring an aerial application maneuver the pilot flew into two 23,000 volt powerlines. The helicopter's rotor blades struck the powerlines, the aircraft turned to the right and descended to the ground.NTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.NTSB NYC87FA251Accident · 2 fatalField investigationFinal reportCessna 152 · Boxborough, MAThe IFR flight from auburn-lewiston, Maine to the manchester, new hampshire VORTAC facility was without incident. Boston center cleared the flight for the vor/dme instrument approach procedure to runway 21 at the uncontrolled stow/minute man airport, stow,…NTSB NYC87FA250Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Gaylordsville, CTThe pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air…NTSB FTW87FA214Accident · 4 fatalField investigationFinal reportBeech 58P · Austin, TXThe plt rcvd a full wx briefing at 0540 CDT & a wx update at 0737 when he filed an IFR flt plan. The flt was without incident with a final cruise alt of 16,000' until 1055:43, when the plt reqd a 'left turn for deviation.' About 3 min later, the ctlr noticed…NTSB CHI87LA211Accident · No injuriesLimited investigationFinal reportCessna 172K · Jefferson, WIThe aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.…NTSB ANC87LA155Accident · No injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot stated that after touchdown on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. He also indicated that the strip was soft and the nose wheel dug in after touchdown.NTSB NYC87FA249Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Riverhead, NYThe Piper PA-28-180 experienced a power loss due to fuel exhaustion while flying over the long island sound. The pilot was unable to reach shore prior to ditching. The ditching was successful and both occupants exited the aircraft without injuries. After…NTSB MIA87LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Morriston, FLDrg a lndg on the student plt's 3rd solo flt, the acft ballooned after it touched down. The student stated that she failed to add power & the stall warning horn sounded. The acft then touched down hard & the nose gear failed.NTSB MIA87LA244Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Belle Glade, FLThe plt stated that he was spraying water to clean out his hopper tank. During approach to land the eng quit. Unable to reach the airstrip the plt landed on a road. On landing rollout on the road he struck a hidden 55 gallon drum with the right wing tip, spun…NTSB MIA87LA243Accident · Minor injuriesLimited investigationFinal reportBeech V-35B · Apalachicola, FLThe plt stated that while on final apch to st. georges arpt he lost power. On an attempt to go around collided with trees, flipped over & came to rest inverted.NTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…NTSB LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…NTSB FTW87FA213Accident · Serious injuriesField investigationFinal reportPartenavia P68C · New Orleans, LAThe plt began an ILS rwy 18R apch at ngt to the lakefront arpt. He rprtd that after the acft broke out of the clouds at 1700', he transitioned to a visual apch. He stated that as he contd, the apch seemed normal, except the VASI lights seemed too FAR down the…NTSB BFO87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Clinton, MDDuring takeoff with the aircraft over the end of the runway, power loss occurred. The pilot landed straight ahead in a field and nosed over. Examination of the aircraft did not disclose any mechanical malfunctions/failures. The engine was started and operated…NTSB ATL87LA256Accident · No injuriesLimited investigationFinal reportHughes 269A · Morristown, TNOne CFI was demonstrating his procedures for autorotations with power recovery to his employer who was also a CFI. This was to insure standardization within the helicopter pilot school. The autorotation was entered from about 700 feet AGL to the departure…NTSB ATL87LA254Accident · No injuriesLimited investigationFinal reportAerostar 600 · Columbus, OHThe scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially…NTSB ATL87FA255Accident · Serious injuriesField investigationFinal reportCessna 402C · Atlanta, GADuring climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.…NTSB SEA87FA185Accident · 2 fatalField investigationFinal reportCessna TR182 · Tillamook, ORDrg arrival, the plt was cleared for an ndb-a apch & received approval to change to the local adzy freq. After that, there was no further radio comm with the acft. Radar data showed the acft crossed over the initial apch fix (iaf) & began a rgt outbound turn…NTSB NYC87DGM03Accident · No injuriesFinal reportWoody Pitts S1 · Irwin, PAThe pilot's inability to maintain control of the aircraft during initial climbout. Inadvertent use of the rudder controls was a factor.NTSB DEN87LA235Accident · No injuriesLimited investigationFinal reportBell 47-G3B2 · Oakley, UTThe plt had just taken off from a confined area surrounded on two sides with electrical power lines. As he attempted to climb, he said his RPM began to bleed off. He stated that he made a right pedal turn to avoid the wires but was unable to prevent a hard…NTSB ATL87LA253Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Cartersville, GAThe plt reported a loss of power on climb out. An off arpt landing attempt resulted in impact with trees and substantial damage to the acft. Temperature and dewpoint were within the range for carburetor ice buildup. Examination of the acft revealed a cruise…NTSB ATL87DEI13Accident · Minor injuriesFinal reportBushby Mustang II · Salem, OHA coml plt (PIC in the left seat) was providing a familiarization flt for a pvt plt (coplt in the rgt seat). The PIC allowed the rgt seat plt to make the takeoff. The PIC rprtd that after the acft lifted off & climbed about 5 to 10 ft, the rgt wing dipped &…NTSB NYC87LA256Accident · No injuriesLimited investigationFinal reportCessna 310N · Williamsport, PAAfter landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut…NTSB NYC87DHA02Accident · 2 fatalFinal reportKolb Twinstar · Hilltown, PAAfter the acft took off, witnesses heard a power change & saw what appeared to be a left turn to return to the grass strip. Subsequently, it entered a descent & crashed in a left wing down, nose low attitude. The passenger was taken to a hospital, but died…NTSB LAX87LA330Accident · No injuriesLimited investigationFinal reportBeech H35 · Avenal, CADuring a pleasure flight, the pilot noted that the oil pressure was reading low. The pilot decided to make a 180 degree turn to land at a nearby airport. En route the oil pressure continued to drop. During the first landing attempt the pilot stated the…NTSB LAX87FA332Accident · 3 fatalField investigationFinal reportBell 206B · Vallejo, CAWhile performing a routine aerial observation flight to inspect the integrity of the pacific gas & electric company's transmission lines, the helicopter crashed after colliding with an unmarked static wire. The line installation was on sloping terrain &…NTSB LAX87FA331Accident · 3 fatalField investigationFinal reportBeech 95 · Monterey, CAThe coml plt was rcvg mult-eng dual instrn in a Beech 95. After tkof, the aircrew began practicing inst apchs. After making an ILS rwy 10 apch to enter left traffic for rwy 28, the flt was clrd onto a south downwind to be sequenced to follow a psa BAE-146.…NTSB CHI87LA209Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marine City, MIPIC lost directional control during lift-off. The aircraft then drifted left, away from the runway, cartwheeled and came to rest upside down. The PIC and passenger exited the aircraft as it started to burn. The PIC stated that he noted immediately a crosswind…NTSB CHI87LA208Accident · No injuriesLimited investigationFinal reportCessna 172PC · Jerseyville, ILThe pilot and one passenger were returning from a local flight. It had become dark during their flight and as the pilot was approaching to land on runway 36 the landing gear of the aircraft struck a drainage ditch approximately 2-3 feet short of the runway.…NTSB LAX87IA326Incident · No injuriesIncident investigationFinal reportMooney M20C · Los Angeles, CAThe plt rprtd that before landing, he went thru the landing checklist, but the green gear light did not illuminate. He contd the landing, & subsequently, the acft touched down & came to rest with the gear retracted. There was evidence the gear was retracted…NTSB DEN87FA234Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Anaconda, MTBoth plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently…NTSB DEN87DTG02Accident · No injuriesFinal reportBell 47G-4A · Minot, NDThe plt rprtd that when he took off fm a nrby nurse truck, the wind was fm the NE at 5 to 7 mph. He made an observation pass across the area to be treated, then bgn a dscndg rgt turn to make a swath run in the opposite drctn. He stated he was unaware of a…NTSB CHI87LA210Accident · No injuriesLimited investigationFinal reportBeech 100 · Batesville, INThe aircraft was approaching hillenbrand airport when the pilot noticed a thunderstorm cell moving in on the airport. The pilot elected to expedite into hillenbrand. During the approach the landing gear was never placed in the extended position. The pilot…NTSB ATL87LA252Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Mc Intosh, ALThe helicopter was being used to set fires to burn off underbrush in a commercial forest prior to cutting of trees. The plt landed the helicopter on a mobile transport trailer at the completion of the day's work. The helicopter engine had been shut off and…NTSB ATL87FA250Accident · Minor injuriesField investigationFinal reportBritish Aerospace 3101 · Atlanta, GAThe airplane was struck by an eastbound, airline employee bus while taxiing south on the ramp to the assigned gate. The bus impacted the acft rt wing tip. A pax in the bus reported that she warned the bus driver to watch out for the airplane prior to the…NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…NTSB NYC87LA247Accident · No injuriesLimited investigationFinal reportCessna 172M · W. Mifflin, PAThe non-certificated pilot took the aircraft without authorization. The aircraft crashed during an attempted landing on runway 10 at allegheny county airport and was substantially damaged. There were two passengers on board but they were not injured. The plt…NTSB MIA87LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Ocala, FLShortly after takeoff, the eng began to lose pwr & the plt was unable to maint alt or return to the arpt. He elected to land on a road, but there was oncoming traffic, so he maneuvered to the left side. Subsequently, the left wing collided with a utility…NTSB LAX87LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Franklin, CAThe student pilot was on his first flight in the aircraft after it had been modified with a tail wheel conversion. During the landing, he lost control and the aircraft ground looped. No preimpact part failure or malfunction was evident.NTSB LAX87LA327Accident · Minor injuriesLimited investigationFinal reportRyan ST3KR · Aguila, AZThe plt made a hard landing and bounced. The acft drifted right before touching down again. Directional control was lost when rt wheel went off the rwy.NTSB FTW87LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roby, TXAfter aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on…NTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…NTSB BFO87LA063Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Richmond, VAThe Balloon was 10th to takeoff in a hound-&-hare competition. Drg flt, the plt noticed the wind had picked up & that the Balloon was drifting towards Richmond. He decided to land in a cemetery & briefed the passengers that the Balloon would touch down hard &…NTSB ANC87LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gold King, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees.NTSB ANC87LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Iowa Ridge, AKThe pilot was awakened in the night at his hunting camp by strong winds estimated at 70 - 80 mph. His airplane came loose at its tie-down and he elected to try and fly it to a safer location. Shortly after take off he lost control of the airplane and crashed.…NTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…NTSB LAX87LA325Accident · 1 fatalLimited investigationFinal reportBeech A45 · Mammoth Lakes, CADuring an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained…