NTSB investigations, 2006
13 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 102 |
|---|---|
| 1983 | 62 |
| 1984 | 60 |
| 1985 | 45 |
| 1986 | 35 |
| 1987 | 44 |
| 1988 | 30 |
| 1989 | 30 |
| 1990 | 22 |
| 1991 | 20 |
| 1992 | 33 |
| 1993 | 36 |
| 1994 | 43 |
| 1995 | 30 |
| 1996 | 28 |
| 1997 | 28 |
| 1998 | 16 |
| 1999 | 21 |
| 2000 | 17 |
| 2001 | 8 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 24 |
| 2006 | 13 |
| 2007 | 22 |
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\") = 2006
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\" = 390)
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") = 2006 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" = 390) 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 NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.NTSB MIA07CA010Accident · No injuriesData collectionFinal reportBeech A36 · St. Augustine, FLThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and on ground collision with a dirt bank.NTSB ANC06CA135Accident · No injuriesData collectionFinal reportCessna 150 · Anchorage, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and subsequent in-flight collision with terrain. A factor associated with the accident was a landing gear collapse.NTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB NYC06CA201Accident · No injuriesData collectionFinal reportBeech B100 · Pawtucket, RIThe pilot's misjudged distance and speed during final approach, which resulted in an undershoot and subsequent gear collapse.NTSB ANC06LA094Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Willow, AKThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and an in-flight collision with trees.NTSB NYC06CA140Accident · No injuriesData collectionFinal reportCessna A185E · Turner, METhe pilot's failure to obtain the proper touchdown point, resulting in a runway undershoot, and substantial damage to the airplane.NTSB ANC06CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Iliamna, AKThe pilot's misjudged distance and altitude, which resulted in an undershoot during final approach to a beach, and subsequent in-flight collision with water and a nose over.NTSB SEA06CA092Accident · No injuriesData collectionFinal reportCessna 182F · Canby, ORThe pilot's misjudgment of altitude resulting in an undershoot. A factor was the berm.NTSB NYC06CA098Accident · No injuriesData collectionFinal reportCessna 310Q · Finleyville, PAThe pilot's misjudged distance/speed during final approach, which resulted in an undershoot and hard landing.NTSB ATL06LA041Accident · No injuriesLimited investigationFinal reportCessna 500 · Burnsville, NCThe pilot's misjudged distance/altitude that led to an undershoot and the pilot's failure to attain the proper touchdown point.NTSB ATL06CA040Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Burlington, NCThe pilot's misjudgment of altitude/distance which resulted in an undershoot of the runway and subsequent impact with the runway collapsing the main landing gear.