NTSB investigations, 1986, SC
3 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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\") = 1986
AND c.\"eventStateOrRegion\" = 'SC' 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\" = 130)
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") = 1986 AND c."eventStateOrRegion" = 'SC' 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" = 130) 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 ATL87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCOne blade of the fixed pitch propeller separated 3' from the hub during a routine instructional flight. The imbalance resulted in a broken engine mount and a total loss of power was experienced. A forced landing was made in a soft field during which, the…NTSB ATL86FA218Accident · No injuriesField investigationFinal reportHughes 269C · Laurens, SCThe plt was flying an underground cable patrol at 500-600 ft AGL when the accident occurred. The plt reported pwr was set at 20' hg, 3,000 RPM when a 'very loud pop' was heard. The plt likened the sound to being hit by ground fire. The acft yawed and the eng…NTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…