NTSB investigations, 1986
3 cases where the first occurrence was “Explosion”.
Cases per year
| 1982 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2004 | 2 |
| 2007 | 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\") = 1986
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\" = 172)
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 172) 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 SEA87MA018Accident · 2 fatalMajor investigationFinal reportCessna 401 · Henderson, NVApproximately 5 1/2 minutes after departure and while the aircraft was climbing enroute, an unknown ignition source triggered an explosion of fuel/air vapor which existed within the interior of the left wing. Wing skin from the upper/lower wing surface was…NTSB NYC86FA183Accident · No injuriesField investigationFinal reportBell B-222A · Staten Island, NYThe helicopter, on a FAR 135 flight was in cruise flt at 900 ft. the plt was checking for called VFR traffic and the co-pilot was occuppied with the RNAV when a loud bang was heard and a sudden yaw was felt. Both crew members stated they reacted as instructed…NTSB NYC86FA092Accident · Minor injuriesField investigationFinal reportAerospatiale AS350D · Philadelphia, PAA Aerospatiale helicopter an a-star under FAR 135 with pilot and 4 passengers onclimb out reaching an altitude of approx 100 to 150' AGL when pilot and passengers heard a loud bang acft lost power. Pilot attempted an auto rotation, due to low airspeed and…