NTSB investigations, 1988, 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\") = 1988
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") = 1988 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 NYC89LA014Accident · Serious injuriesLimited investigationFinal reportLet L13 · Warren, VTPilot's improper supervision of flight, permitted the student to not maintain the proper airspeed and stall the glider and crash into the ground.NTSB NYC89LA009Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Rutland, VTThe accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…NTSB NYC88LA212Accident · 1 fatalLimited investigationFinal reportCessna 152 · Swanton, VTThe plt took the passenger (his wife) on a short flt, which was her 1st flt. She was described as apprehensive. Before going back to the parking area after landing, the plt taxied to the terminal bldg for his wife to deplane. He stopped the acft with the left…NTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…NTSB NYC88LA198Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Montpelier, VTEngine power loss due to fuel contamination of water and rust particles in fuel system.NTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…NTSB NYC88LA111Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Rutland, VTPrior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began…NTSB NYC88LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Newport, VTDuring landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over.NTSB NYC88LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · West Dover, VTThe PA-28 landed short of the runway and struck a snowbank receiving substantial damage. The pilot when interviewed by the FAA said the engine did not miss and wasn't cutting out and that he would have to 'take the majority of the blame'. On NTSB form 6120.1,…NTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…NTSB NYC88LA066Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stowe, VTThe Cessna 210 took off and shortly thereafter experienced a loss of power. The pilot was unable to get the engine restarted and made an off-airport landing in a grove of trees. On-scene examination by the FAA showed that the fuel selector was on the left…