Skip to content

NTSB investigations, VT

11 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'VT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
  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 c."eventStateOrRegion" = 'VT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)
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 DEN07CA117Accident · No injuriesData collectionFinal reportCessna 182R · Montpelier, VTThe pilot's improper flare and subsequent hard landing.Jul 10, 2007 · N9890H · Substantial damage NTSB NYC04CA135Accident · No injuriesData collectionFinal reportMooney M20R · Warren, VTThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the wind shear as reported by the pilot.May 29, 2004 · N53WM · Substantial damage NTSB NYC99LA228Accident · No injuriesLimited investigationFinal reportPiper PA-601P · West Dover, VTwas the diverted attention of the pilot, which resulted in his failure to maintain airspeed, and his failure to lower the landing gear prior to landing.Aug 8, 1999 · N9756Q · Substantial damage NTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.Apr 28, 1996 · N98574 · Substantial damage NTSB NYC91LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Rutland, VTThe student pilot improper recovery from a bounced landing which resulted in the collapsing of the nose gear. A factor related to the accident was the student pilot's lack of total flight experience.Jul 4, 1991 · N69061 · Substantial damage NTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.Aug 19, 1989 · N9335E · Substantial damage NTSB NYC89LA138Accident · No injuriesLimited investigationFinal reportHughes 269A · Swanton, VTThe pilot failed to maintain directional control.May 27, 1989 · CFBMF · Substantial damage 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…Sep 18, 1987 · N2216L · Substantial damage NTSB NYC85LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152A · Post Mills, VTAfter reviewing air maneuvers, a normal apch was made to land on rwy 22. The acft landed on all 3 wheels & bounced into the air, then it went to the left of the rwy. While the plt was turning right to avoid trees & to recover from the bounced landing, the…Sep 4, 1985 · N4976A · Substantial damage NTSB NYC85LA050Accident · No injuriesLimited investigationFinal reportBeech P35 · Morrisville, VTPlt noted accumulation of rime ice in flt. On NDB approach, VFR conditions reached about 7 miles from runway, IFR flt plan cancelled and straight-in visual approach performed. Crossing threshold at about 2O ft AGL, plt reduced throttle and acft immediately…Dec 27, 1984 · N1DL · Substantial damage NTSB NYC82FNC07Accident · No injuriesFinal reportAerotek-Pitts S-2A · Warren, VTThe pilot reported that before landing, he noticed heavy wind shear while on downwind and base. Reportedly, he encountered a severe sink after turning from base to final approach. He added full power, but was unable to stop the descent before contacting the…Apr 23, 1982 · N388N · Substantial damage