NTSB investigations: Piper PA-18, FL
10 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 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2021 | 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\" = 'FL' 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" = 'FL' 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 ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.NTSB MIA98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · St. Petersburg, FLThe intentional operation of the airplane by the pilot and the company/operator with the known deficiencies in equipment (worn carburetor). Also, the poor preflight planning by the pilot for his failure to recognize that the carburetor heat control was…NTSB MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.NTSB MIA92LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ft Walton Beach, FLThe pilot misjudged his altitude while turning on final approach over water to land at an airport.NTSB MIA85LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · St.Petersburg, FLThe pilot was assigned an aircraft with a recently overhauled engine to tow a banner. He preflighted, started and ran-up the engine 3 times. Each time the engine ran rough and lost RPM on magneto checks. After each occurrence, companymaintenance personnel…NTSB MIA82DA153Accident · Minor injuriesFinal reportPiper PA-18 · Kenneth City, FLWhile cruising the aircraft oil pressure dropped and smoke entered the cockpit, so made a forced landing in a small field. The aircraft hit a stump and nosed over. An investigation revealed a broken oil line to a pressure gauge and oil leaked on a hot exhaust…NTSB MIA79FKT69Accident · No injuriesClosedPiper PA-18 · Ft Lauderdale, FLNTSB MIA68A0078Accident · 2 fatalClosedPiper PA-18 · Deland, FLNTSB UNK65X1459Accident · No injuriesClosedPiper PA-18 · Ft Pierce, FLNTSB UNK64X1125Accident · No injuriesClosedPiper PA18 · Ft Pierce, FL