NTSB investigations: Piper PA-28-181, NH
5 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1977 | 1 |
|---|---|
| 1982 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 2000 | 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\" = 'NH' 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 ('7102807', '7102832'))
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" = 'NH' 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 ('7102807', '7102832'))
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 NYC00LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Center Harbor, NHThe pilot-in-command attempted a low pass and misjudged his altitude.NTSB NYC88LA243Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Keene, NHThe plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…NTSB NYC87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Newport, NHOn takeoff the aircraft failed to gain sufficient airspeed to maintain flight. The takeoff was aborted after reaching 200 feet altitude and the aircraft was landed on the runway. The aircraft continued off the end of the runway and collided with a sandbank.…NTSB NYC82DA047Accident · No injuriesFinal reportPiper PA-28-181 · Jaffrey, NHDuring takeoff, the engine lost power at about 40 to 50 ft AGL. The aircraft was landed back on the runway with about 400 ft remaining. It hit a snowbank at the end of the runway at about 40 to 50 knots. The plane bounced and came to rest after traveling…NTSB NYC77FA052Accident · 1 fatalClosedPiper PA-28 · Nashua, NH