NTSB investigations: Piper PA-31-310, 1982
8 cases on aircraft the registry lists as Piper PA-31-310. 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 |
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 5 |
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 11 |
| 1976 | 4 |
| 1977 | 7 |
| 1978 | 11 |
| 1979 | 11 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 8 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 3 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2001 | 1 |
| 2003 | 3 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2017 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103102'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103102'))
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 MIA83FA017Accident · 8 fatalField investigationFinal reportPiper PA-31 · Missing Acft (Atlantic Ocean)The flt departed anguilla at 0803 ast. At 0805 the plt radioed st. maarten & filed a VFR flt plan to st. thomas. The flt plan showed a direct route of flt at 4,500 ft MSL with a time enroute of 45 min. The flt failed to arrive at the destination. Search…NTSB ATL83FA003Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Dyersburg, TNAt 30 mi north of the destination, the inboard side of the right eng cowl popped loose & began vibrating severely, the plt was concerned that the cowling would break loose & strike the vert of horiz stabilizer so he feathered the r eng. Atthis point, the arpt…NTSB ATL82DA284Accident · No injuriesFinal reportPiper PA-31 · London, KYThe aircraft was on a flight from palm beach, FL to London, KY. Five miles short of runway 23 at London, both engines quit and the aircraft made a forced landing. Post crash examination revealed less than one gallon of fuel on board.NTSB NYC82FA134Accident · No injuriesField investigationFinal reportPiper PA-31 · Bennington, VTWhile on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine…NTSB CHI82DA050Accident · No injuriesFinal reportPiper PA-31-310 · East Saint Loui, ILThe aircrew did not key the approach lights on during the first ILS approach at night. Therefore, a missed approach was made. On the second approach, the lead-in lights were visible from over one mile. However, the visibility was much worse at touchdown,…NTSB MIA82FLD15Accident · Serious injuriesFinal reportPiper PA-31 · Ft. Pierce, FLThe aircraft crashed at night near a private strip in marginal weather conditions. The gear was found in the up position, the right engine was broken off, the nose section was crushed back to the windshield, and both propellers were bent and twisted. About…NTSB FTW82FRG21Accident · 1 fatalFinal reportPiper PA-31 · Port Mansfield, TXThe aircraft crashed and burned about 1/2 mile from the approach end of runway 12. A witness reported that "the plane just fell" while the pilot was making a sharp turn. An estimated 1500 lbs of marijuana was on board.NTSB DCA82AA009Accident · 2 fatalFinal reportPiper PA-31 · Ithaca, NYThe acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…