NTSB investigations, 1994
6 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 21 |
| 1988 | 10 |
| 1989 | 14 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 8 |
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\") = 1994
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\" = 330)
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") = 1994 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" = 330) 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 MIA95LA050Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Arcadia, FLPoor in flight planning/decision by the pilot for electing to land with fog on the airstrip. Contributing to the accident was failure of the pilot to obtain a formal preflight weather briefing and his failure to fully apply the brakes (normal) after landing.…NTSB NYC95LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Niagra Falls, NYThe pilot's inadequate weather evaluation and the on ground encounter with gusty winds.NTSB MIA95LA020Accident · No injuriesLimited investigationFinal reportCessna 182-D · Deland, FLThe failure of the pilot to compensate for the gusty wind conditions during taxi for takeoff.NTSB MIA94LA150Accident · No injuriesLimited investigationFinal reportMooney M20-J · Apalachicola, FLThe pilot's inadequate compensation for the crosswind resulting in not maintaining alignment with the runway and the pilot's delay in aborting the landing. The crosswind was a factor.NTSB ATL94LA066Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chamblee, GAThe pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.NTSB DCA94IA032Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Chantilly, VAThe flightcrew's failure to maintain directional control during a rejected takeoff. Contributing factors were the wet and icy runway.