NTSB investigations: Piper PA-18-150, VA
13 cases on aircraft the registry lists as Piper PA-18-150. 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 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1999 | 1 |
| 2003 | 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\" = 'VA' 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 ('7101828', '7104221', '7102835'))
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" = 'VA' 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 ('7101828', '7104221', '7102835'))
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 NYC03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, VALoss of engine power due to unknown circumstances.NTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.NTSB ATL83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Front Royal, VAThe acft nosed over during landing. There were no mechanical malfunctions. The pilot said that as he landed, the acft skipped. He said the acft was relanded but the tail came up. The tail was lowered, came up again and with back pressure on the control stick…NTSB ATL83FA186Accident · 1 fatalField investigationFinal reportPiper PA-18 · Ft. Pickett, VAThe acft collided with the ground at ft Pickett shortly after a similiar acft was seen trying to approach blackstone army airfield. This acft made a go-around and disappeared to the south. The wrecked acft was found 3.5 miles south of the arpt 8 months later.…NTSB IAD79FA076Accident · 1 fatalClosedPiper PA-18 · Warrenton, VANTSB IAD77DIA15Accident · No injuriesClosedPiper PA-18 · Nokesville, VANTSB NYC73AN100Accident · 1 fatalClosedPiper PA-18 · Providence Frg, VANTSB IAD71FID07Accident · 1 fatalClosedPiper PA-18 · Virginia Beach, VANTSB DIA69A0002Accident · 2 fatalClosedPiper PA-18S · Swords Creek, VANTSB DIA68D0025Accident · No injuriesClosedPiper PA-18 · Brookneal, VANTSB UNK65X1510Accident · No injuriesClosedPiper PA-18 · Martinsville, VANTSB NYC65F0005Accident · No injuriesClosedPiper PA-18 · Back Bay, VANTSB UNK65X0808Accident · 1 fatalClosedPiper PA-18 · Chase City, VA