NTSB investigations: NONE, 2001
7 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Hard landing”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 7 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 5 |
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\") = 2001
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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") = 2001
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW02LA059Accident · Serious injuriesLimited investigationFinal reportCameron Balloons Z-90 · Mcintosh, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. A contributing factor was the high wind weather condition.NTSB FTW02LA025Accident · Serious injuriesLimited investigationFinal reportCameron Balloon A-210 · Albuquerque, NMthe pilot's excessive descent rate during the landing approach, which resulted in a hard landing. Contributing factors were the high wind conditions and the lack of suitable terrain for the landing.NTSB FTW02LA011Accident · Serious injuriesLimited investigationFinal reportCameron 105 · Albuquerque, NMTher pilot's delay to compensate for changing weather conditions in-flight. Contributing factors were the high winds and an inaccurate weather forcast.NTSB DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.NTSB LAX01LA249Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Minden, NVThe student pilot's early deployment of full spoilers, resulting in an excessive sink rate and subsequent hard landing. A factor was the instructor's lack of time to take remedial action.NTSB IAD01LA080Accident · Serious injuriesLimited investigationFinal reportAerostar International RXS-8 · Flemington, NJpilot's continued flight into known adverse weather conditions, which resulted in a hard landing. A factor was the downdrafts.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.