NTSB investigations, 2002, UT
6 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 6 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 4 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'UT' 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\" = 230)
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") = 2002 AND c."eventStateOrRegion" = 'UT' 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" = 230) 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 DEN03LA001Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Morgan, UTthe pilot's inadequate inflight planning and decision which resulted in an unsuitable off-field landing site. A contributing factor was downdraft weather conditions.NTSB DEN02FA089Accident · 4 fatalField investigationFinal reportMooney M20A · Marysvale, UTthe pilot's poor in-flight decision to fly so close to the ridge (looking for animals). Contributing factors were the mountainous terrain condition, the downdraft weather conditions in high mountains, and the high density altitude weather condition.NTSB DEN02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tooele, UTthe pilot-in-command failure to obtain/maintain proper rate of climb, resulting in a collision with terrain. Contributing factors were the high density altitude and exceeding the airplane's forward center of gravity limit.NTSB DEN02TA069Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Fillmore, UTthe pilot's failure to follow proper procedures/directives, and the airplane's inability to climb while maneuvering after takeoff. Factors contributing to the accident were improperly mixed aerial application materials (fire retardant slurry), the high…NTSB FTW02FA130Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Alpine, UTThe pilot's failure to maintain clearance with terrain and continued flight into known adverse weather conditions. Contributing factors were the fog and rain weather conditions.NTSB DEN02LA023Accident · 1 fatalLimited investigationFinal reportBeech V35B · American Fork, UTThe pilot's poor judgment in that he intentionally initiated VFR flight into instrument meteorological conditions. Contributing factors were low ceiling and obscuration, and the pilot's lack of recent instrument time.