NTSB investigations: Piper PA-32-260, LA
18 cases on aircraft the registry lists as Piper PA-32-260. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1988 | 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 ('7103206'))
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 ('7103206'))
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 FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…NTSB FTW84LA350Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Minden, LADuring a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.NTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…NTSB FTW81DRD07Accident · Minor injuriesClosedPiper PA-32 · Loreauville, LANTSB FTW80FA116Accident · 4 fatalClosedPiper PA-32 · Goodwill, LANTSB FTW80FRD09Accident · No injuriesClosedPiper PA-32 · Cameron, LANTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LANTSB FTW76FRD31Accident · No injuriesClosedPiper PA-32 · Convent, LANTSB FTW76AF021Accident · 2 fatalClosedPiper PA-32 · Alexandria, LANTSB FTW76AF031Accident · 2 fatalClosedPiper PA-32 · Bernice, LANTSB FTW75FRD05Accident · No injuriesClosedPiper PA-32 · Port Barre, LANTSB FTW74FRJ04Accident · No injuriesClosedPiper PA-32 · Minden, LANTSB FTW72AF080Accident · 2 fatalClosedPiper PA-32 · Hammond, LANTSB FTW71DRF29Accident · No injuriesClosedPiper PA-32 · Georgetown, LANTSB FTW69F0412Accident · No injuriesClosedPiper PA-32 · Sarepta, LANTSB FTW67D0597Accident · No injuriesClosedPiper PA-32 · Baton Rouge, LANTSB FTW67D0248Accident · No injuriesClosedPiper PA-32 · Freemason Isl., LANTSB FTW66F0466Accident · Serious injuriesClosedPiper PA-32 · Alexandria, LA