Skip to content

NTSB investigations, 1988

10 cases where the first occurrence was “On ground/water encounter with weather”.

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 year(c."eventDate") = 1988 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" = 330) 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 year(c.\"eventDate\") = 1988
    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\" = 330)
  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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330)
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 DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, COSep 19, 1988 · N66076 · Destroyed NTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.Jul 4, 1988 · N4186E · No damage NTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.Jun 9, 1988 · N1103F · Substantial damage NTSB DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMMay 1, 1988 · N618T · Substantial damage NTSB DEN88LA103Accident · No injuriesLimited investigationFinal reportCessna 172G · Las Vegas, NMThe private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of…May 1, 1988 · N6059R · Substantial damage NTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…Apr 6, 1988 · N64508 · Substantial damage NTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…Apr 5, 1988 · N62551 · Substantial damage NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…Mar 24, 1988 · N72PF · Substantial damage NTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…Feb 9, 1988 · N4509J · Substantial damage NTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…Jan 14, 1988 · N1879P · Substantial damage