NTSB investigations: NONE, AZ
12 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2005 | 1 |
| 2007 | 1 |
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\" = 'AZ' 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')
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\" = 240))
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" = 'AZ' 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')
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" = 240))
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 SEA07CA175Accident · No injuriesData collectionFinal reportBurkhart Grob G102 Std Astir III · Wickenburg, AZThe pilot's inadequate compensation for wind conditions which resulted in an inflight collision with a cactus tree while landing. The loss of thermal lift, tailwind, gusts, and tree were contributing factors to the accident.NTSB LAX06CA012Accident · Serious injuriesData collectionFinal reportAerostar RX-8 · Globe, AZthe pilot's encounter with a wind gust during landing.NTSB LAX00LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly II · Phoenix, AZThe pilot's failure to use pibals or other on site wind determination devices, and his subsequent failure to detect adverse wind conditions prior to launch of the balloon.NTSB LAX99FA273Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 11 · Cave Creek, AZAn unforecast encounter with a low level microburst that resulted in a distortion of the balloon envelope, an excessive outflow of hot air (loss of lift), creating an excessive rate of descent that was beyond the performance capability of the balloon to…NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB LAX95LA036Accident · Serious injuriesLimited investigationFinal reportThunder and Colt TC-180 · Peoria, AZthe flight's encounter with unforecasted high winds which resulted in a hard landing.NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.NTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZNTSB LAX84LA492Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Marana, AZThe plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with…NTSB LAX84LA257Accident · Serious injuriesLimited investigationFinal reportRaven S-55A-707 · Glendale, AZDuring a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry…NTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…