NTSB investigations: NONE, ID
16 cases on aircraft whose registry engine model is NONE. 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
| 1968 | 2 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2011 | 2 |
| 2018 | 2 |
Where
Latest 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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 DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…NTSB WPR11FA392Accident · 1 fatalField investigationFinal reportBriegleb BG-12B · Moore, IDThe pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…NTSB WPR11CA342Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Preston, IDThe glider's impact with crops during the off-airport landing.NTSB SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.NTSB SEA04LA146Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Homedale, IDThe loss of engine power for an undetermined reason while maneuvering at low altitude, which resulted in a hard landing.NTSB SEA01LA173Accident · 1 fatalLimited investigationFinal reportKaman HH-43 · Bonners Ferry, IDThe pilot's inadequate visual lookout which lead to his failure to maintain clearance from the nearby trees while in a high-hover. Factors include mountainous/hilly terrain, and tall trees in the area where the helicopter was hovering.NTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.NTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.NTSB SEA94LA186Accident · No injuriesLimited investigationFinal reportEiriavion PIK20D-78 · Rexberg, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a vehicle parked near the runway.NTSB SEA91LA147Accident · No injuriesLimited investigationFinal reportLet L-13 · Driggs, IDThe pilot misjudged his distance and altitude to the runway during the approach and failed to attain the proper touchdown point for landing. His lack of experience in the make and model of glider was a related factor.NTSB SEA82DA092Accident · No injuriesFinal reportBlanik L-13 · Driggs, IDThe pilot held a commercial, airline transport certificate, but had only a student glider certificate. During a towed takeoff, witnesses observed the spoilers extend after about 200 ft of ground roll. The tow pilot gave an arm signal to indicate a problem.…NTSB SEA78DYA09Accident · No injuriesClosedLet-Np-K L-13 · Driggs, IDNTSB SEA77DYA22Accident · No injuriesClosedSchleicher KA-6 · Geneva, IDNTSB SEA69D0093Accident · Minor injuriesClosedSchweizer SGS126 · Hailey, IDNTSB SEA69D0079Accident · No injuriesClosedSchweizer SGS2-8 · Boise, ID