NTSB investigations, 1987, VT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1964 | 20 |
|---|---|
| 1965 | 16 |
| 1966 | 9 |
| 1967 | 15 |
| 1968 | 15 |
| 1969 | 18 |
| 1970 | 11 |
| 1971 | 14 |
| 1972 | 20 |
| 1973 | 18 |
| 1974 | 11 |
| 1975 | 16 |
| 1976 | 21 |
| 1977 | 9 |
| 1978 | 15 |
| 1979 | 16 |
| 1980 | 10 |
| 1981 | 3 |
| 1982 | 10 |
| 1983 | 13 |
| 1984 | 9 |
| 1985 | 11 |
| 1986 | 13 |
| 1987 | 13 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 10 |
| 1992 | 3 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 11 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 7 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 11 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 3 |
Where
Latest cases
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 year(c.\"eventDate\") = 1987
AND c.\"eventStateOrRegion\" = 'VT' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1987 AND c."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA' 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 NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB NYC88FA042Accident · 2 fatalField investigationFinal reportMooney M20K · Danby, VTThe pilot was on a VFR cross country flight when the aircraft descended rapidly and collided with trees. Several witnesses reported hearing extensive engine surges. Witnesses reported seeing the acft maneuvering in a highly erratic manner, then begin a nose…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 NYC87LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, VTWhile cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped…NTSB NYC87LA259Accident · No injuriesLimited investigationFinal reportBeech 23 · Montpelier, VTDuring a landing, the aircraft bounced and the student pilot attempted to correct the situation. However, the aircraft touched down and bounced again, then became uncontrollable. Subsequently, it veered off the left side of the runway and hit a parked Cessna…NTSB NYC87LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vergennes, VTDuring a landing attempt at basin harbor airport, the pilot came in high and fast. He did not correct and failed to go around. He overran the runway and crashed into a ditch causing substantial damage to the aircraft. The plt did not file an acc report.NTSB NYC87DNC12Accident · Serious injuriesFinal reportCessna 150L · Heartwellville, VTThe pilot of the Cessna 150 was on a solo flight to practice several maneuvers including stalls. At about 4000 ft MSL, then aircraft was climbing with power on when it stalled and went into a spin. The pilot managed to get the nose up just prior to impact…NTSB NYC87DNC11Accident · No injuriesFinal reportBeech C23 · Vergennes, VTThe pilot of the Beech C23 had taken off and was returning to the airport due to deteriorating weather conditions. The pilot attempted to land on runway 20, but made a go around because of gusty winds. On the second attempt to land on the same runway, the…NTSB NYC87DNC07Accident · 1 fatalFinal reportMcculloch Monerai "S" · Springfield, VTThe monerai 's' (N54MS, a pwrd glider) experienced an inflt failure of the left wing spar & crashed. An investigation revealed the acft was being operated in excess of its max gross wt limit of 450 lbs. The plt of an unpowered monerai said he & 3 others…NTSB NYC87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Rutland, VTDrg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was…NTSB NYC87LA108Accident · No injuriesLimited investigationFinal reportBoeing 727 · Burlington, VTIn preparation for powering away from the gate, one groundman was stationed off the left nose of the acft and another was positioned by the left wing tip. The plt advanced the throttles and initiated a right turn. The throttles were brought back to idle…NTSB NYC87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Shelburne, VTPilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage.NTSB NYC87FA063Accident · 1 fatalField investigationFinal reportMooney M20C · Highgate, VTAccording to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…