NTSB investigations: Piper PA-18, ME
13 cases on aircraft the registry lists as Piper PA-18. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 2002 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'ME' 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 ('7101802'))
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" = 'ME' 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 ('7101802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Turner, METhe pilot's misjudgment of distance which resulted in an overrun.NTSB NYC85LA218Accident · No injuriesLimited investigationFinal reportPiper PA-18-95 · Millinocket, METhe plt reported that he was departing from south twin lake in winds that were from 270 deg at 12 gusting 20 KTS. After the acft lifted off the water, he started a slight turn. He stated that at about that time, a gust of wind simultaneously lifted the nose &…NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…NTSB NYC80FA048Accident · Serious injuriesClosedPiper PA-18 · Patten, MENTSB NYC80FA021Accident · 2 fatalClosedPiper PA-18 · East Machias, MENTSB NYC79DNC38Accident · No injuriesClosedPiper PA-18 · Spruce Head, MENTSB NYC77FNC13Accident · Serious injuriesClosedPiper PA-18 · Millinocket, MENTSB NYC77FNC09Accident · No injuriesClosedPiper PA-18 · Bangor, MENTSB NYC75AN056Accident · Minor injuriesClosedPiper PA-18 · Patten, MENTSB NYC74DNC44Accident · No injuriesClosedPiper PA-18 · Winslow, MENTSB NYC72FNC04Accident · Minor injuriesClosedPiper PA-18S · Auburn, MENTSB NYC71DFG06Accident · No injuriesClosedPiper PA-18 · Sebago Lake, MENTSB UNK65X0442Accident · 1 fatalClosedPiper PA-18S · Kokadjo, ME