NTSB investigations, 1985, AL
3 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 2 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 6 |
| 1996 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 4 |
| 2007 | 2 |
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\" = 'AL' 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\" = 240)
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" = 'AL' 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" = 240) 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 ATL86FA010Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Hamilton, ALAt 1450 CDT, while the plt was cruising at 11,000', ARTCC broadcast info concerning SIGMET 17C, warning plts of thunder-storms with tops to FL 450. At 1613, radar data showed the acft at 11,300'. When asked about his alt, the plt replied he was in a cell &…NTSB ATL85LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Clanton, ALThe acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await…NTSB ATL85FA112Accident · 4 fatalField investigationFinal reportBell 206L · Dauphin Island, ALPlt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of…