NTSB investigations, ID
13 cases where NTSB found Operating environment.
Cases per year
| 2008 | 6 |
|---|---|
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2021 | 1 |
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0301'))
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0301')) 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 WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB WPR14CA314Accident · No injuriesData collectionFinal reportCessna 182Q · Warren, IDThe pilot's attempt to depart on an unpaved road, which he mistook for the unpaved runway. Contributing to the accident was the fact that the road and the runway were conjoined for the first few hundred feet of the runway.NTSB WPR14LA271Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Big Creek, IDThe pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…NTSB WPR13CA199Accident · No injuriesData collectionFinal reportCessna A185E · Cottonwood, IDThe pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.NTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.NTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.NTSB LAX08CA210Accident · No injuriesData collectionFinal reportCessna TU206G · Coeur d'Alene, IDThe pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.NTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.NTSB LAX08CA245Accident · No injuriesData collectionFinal reportCessna 180 · Atlanta, IDThe pilot's misjudged speed and distance during the intentional touchdown in the last half of the runway, which resulted in a landing overrun. Contributing to the accident was the muddy runway condition.NTSB LAX08CA125Accident · Minor injuriesData collectionFinal reportGrumman AA-5A · Atlanta, IDThe pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.NTSB SEA08FA116Accident · 3 fatalField investigationFinal reportCessna 172N · McCall, IDThe failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.NTSB SEA08CA126Accident · No injuriesData collectionFinal reportCessna 172M · Dixie, IDThe pilot's failure to maintain adequate clearance from the vegetation during takeoff.