Skip to content

NTSB investigations: Piper PA-28-180, KS

33 cases on aircraft the registry lists as Piper PA-28-180. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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" = 'KS' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808')) 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\" = 'KS' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
  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" = 'KS' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
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 CHI99FA346Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Fort Scott, KSthe failure of the pilot to maintain control of the aircraft. Factors were the pilot's lack of total experience, his lack of familiarity with the airplane, and the stall/spin encountered.Sep 21, 1999 · N8446W · Destroyed NTSB CHI96FA120Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lincoln, KSthe pilot became spatially disoriented and failed to maintain control of the airplane. The factors involved were the pilot encountered VFR flight into IMC, pressure induced by conditions/events, low ceilings, and the dark light conditions.Mar 29, 1996 · N8214W · Destroyed NTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.Feb 17, 1996 · N9793J · Destroyed NTSB CHI94LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lindsborg, KSwas the pilot-in-command's failure to refuel the airplane during the flight. Factors were fuel exhaustion, the sign, and the pilot-in-command's lack of total experience in type of airplane.Mar 2, 1994 · N3592R · Substantial damage NTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.Jan 25, 1993 · N444TD · Destroyed NTSB CHI92FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Ness City, KSThe pilot-in-command's (CFI) failure to maintain control of the airplane.Sep 5, 1992 · N5272L · Destroyed NTSB MKC84LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manhattan, KSThe plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear…Dec 25, 1983 · N55890 · Substantial damage NTSB MKC82DA121Accident · No injuriesFinal reportPiper PA-28-180 · Lawrence, KSThe pilot entered the traffic pattern for landing on runway 19. He stated he was not aware of construction on the runwayuntil the aircraft's nose was lowered during the landing roll. By then, the aircraft's speed was too slow to go-around. He turned off the…Jul 13, 1982 · N15970 · Substantial damage NTSB MKC81FCQ04Accident · No injuriesClosedPiper PA-28 · Wichita, KSNov 20, 1980 · N8807J · Substantial damage NTSB MKC77DCQ25Accident · Minor injuriesClosedPiper PA-28 · Wakeeney, KSMar 18, 1977 · N7221W · Substantial damage NTSB MKC76FCQ71Accident · Serious injuriesClosedPiper PA-28 · Coffeyville, KSAug 3, 1976 · N4819L · Substantial damage NTSB MKC75DCQ25Accident · No injuriesClosedPiper PA-28 · St Francis, KSNov 27, 1974 · N6367J · Substantial damage NTSB MKC74DCQ39Accident · No injuriesClosedPiper PA-28 · Neodesha, KSMay 12, 1974 · N2696T · Substantial damage NTSB MKC73FCQ13Accident · No injuriesClosedPiper PA-28 · Kalvesta, KSSep 13, 1972 · N7150W · Substantial damage NTSB MKC72DCQ48Accident · Minor injuriesClosedPiper PA-28 · Lamar, KSMar 31, 1972 · N1962T · Substantial damage NTSB MKC72FCQ20Accident · Serious injuriesClosedPiper PA-28 · Hutchinson, KSAug 17, 1971 · N1299G · Minor damage NTSB MKC72DCQ13Accident · No injuriesClosedPiper PA-28 · Oakley, KSJul 24, 1971 · N5172L · Substantial damage NTSB MKC72DCQ04Accident · No injuriesClosedPiper PA-28 · Oberlin, KSJun 20, 1971 · N7771W · Substantial damage NTSB MKC70AK069Accident · 2 fatalClosedPiper PA-28 · Lyndon, KSJun 7, 1970 · N7808N · Destroyed NTSB MKC70FCG24Accident · No injuriesClosedPiper PA-28 · Olathe, KSApr 27, 1970 · N6546J · Substantial damage NTSB MKC70DCQ04Accident · No injuriesClosedPiper PA-28 · St Francis, KSJan 26, 1970 · N5121G · Substantial damage NTSB MKC70DCG02Accident · No injuriesClosedPiper PA-28 · Olathe, KSJan 21, 1970 · N3592R · Substantial damage NTSB MKC70F0263Accident · Serious injuriesClosedPiper PA-28 · Beaumont, KSNov 9, 1969 · N5257L · Substantial damage NTSB MKC69A0006Accident · 1 fatalClosedPiper PA-28 · Ness City, KSJul 28, 1968 · N5148L · Destroyed NTSB MKC68F0548Accident · Serious injuriesClosedPiper PA-28 · Hays, KSApr 11, 1968 · N9153J · Substantial damage NTSB MKC67D0587Accident · No injuriesClosedPiper PA-28 · Plainville, KSMay 18, 1967 · N7591W · Substantial damage NTSB MKC67D0572Accident · No injuriesClosedPiper PA-28 · Hugoton, KSApr 19, 1967 · N8405W · Substantial damage NTSB MKC67D0397Accident · No injuriesClosedPiper PA-28 · Liberal, KSDec 28, 1966 · N8192W · Substantial damage NTSB MKC66D0450Accident · No injuriesClosedPiper PA-28 · Opeka, KSFeb 26, 1966 · N7539W · Substantial damage NTSB MKC65F0027Accident · No injuriesClosedPiper PA-28 · Sublette, KSJan 24, 1965 · N7985W · Substantial damage NTSB UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSDec 27, 1964 · N7700W · Substantial damage NTSB UNK64X2958Accident · No injuriesClosedPiper PA28 · Gardner, KSJul 21, 1964 · N7011W · Substantial damage NTSB UNK64X1648Accident · 4 fatalClosedPiper PA28 · Wichita, KSMay 7, 1964 · N7221W · Destroyed