NTSB investigations: Piper PA-24-250, LA
17 cases on aircraft the registry lists as Piper PA-24-250. 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 | 3 |
|---|---|
| 1965 | 4 |
| 1966 | 2 |
| 1968 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 2015 | 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\" = 'LA' 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 ('7102404'))
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" = 'LA' 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 ('7102404'))
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 CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB FTW85LA326Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Farmerville, LAThe plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…NTSB FTW81DRJ20Accident · No injuriesClosedPiper PA-24 · Many, LANTSB FTW73FRD17Accident · No injuriesClosedPiper PA-24 · New Orleans, LANTSB FTW73DRJ14Accident · Minor injuriesClosedPiper PA-24 · West Monroe, LANTSB FTW71DRJ07Accident · No injuriesClosedPiper PA-24 · Cottonport, LANTSB FTW70FRD15Accident · No injuriesClosedPiper PA-24 · Opelousas, LANTSB FTW69A0046Accident · 5 fatalClosedPiper PA-24 · Oakdale, LANTSB FTW66F0491Accident · No injuriesClosedPiper PA-24 · Montgomery, LANTSB FTW66A0062Accident · 1 fatalClosedPiper PA-24 · Jonesboro, LANTSB FTW66A0006Accident · 4 fatalClosedPiper PA-24 · Lake Charles, LANTSB FTW66F0005Accident · No injuriesClosedPiper PA-24 · Baton Rouge, LANTSB UNK65X1339Accident · No injuriesClosedPiper PA24 · Lake Charles, LANTSB UNK65X1263Accident · No injuriesClosedPiper PA24 · Baton Rouge, LANTSB UNK64X3534Accident · No injuriesClosedPiper PA24 · Baton Rouge, LANTSB UNK64X1873Accident · No injuriesClosedPiper PA24 · Freemason Is, LANTSB UNK64X0704Accident · 2 fatalClosedPiper PA24 · New Orleans, LA