NTSB investigations, 1985, GA
4 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest 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\") = 1985
AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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") = 1985 AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ATL86IA051Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 B4-203 · Atlanta, GADuring takeoff initial climb the aircraft experienced an uncontained failure of the no 1 engine. The pilot returned to the airport and landed without further incident. Post incident examination disclosed four broken turbine mid frame strut studs. The fracture…NTSB ATL86FKG03Accident · No injuriesFinal reportCessna 182P · Hawkinsville, GAThe acft caught fire during a forced lndg after losing eng power during cruise. The plt approached a hi-way for landing and smoke filled the cockpit. During rollout fire came thru the firewall and the plt evacuated the moving acft. The unoccupied acft…NTSB ATL85LA214Accident · Minor injuriesLimited investigationFinal reportWag-Aero Cubbie (J-3) · Stockbridge, GADuring a departure, the eng had a partial loss of power. The plt reported that after climbing to about 75 ft, neither the acft's speed nor alt would increase. He lowered the nose to increase the eng RPM & speed, but the eng did not respond. Subsequently, the…NTSB ATL85FA181Accident · Minor injuriesField investigationFinal reportPiper PA-32R-301T · Newnan, GAThe eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then…