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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2210302', '2210400')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2210302', '2210400')
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 WPR25LA106Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Heber City, UTThe pilot’s loss of directional control during landing, which resulted in a collision with a snowbank.NTSB ERA24LA383Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Carrollton, OHA failure of the left main landing gear due to fatigue cracking, which resulted the airplane’s left wing contacting the ground.NTSB CEN21LA403Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Gunnison, COThe pilot’s failure to maintain directional control of the airplane after landing with a quartering tailwind.NTSB ERA21FA165Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1 · Cave Spring, GAThe pilot's inadequate visual lookout and failure to maintain clearance from a power line.NTSB WPR21LA147Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Ogden, UTThe pilot's failure to maintain directional control during the landing roll with a light crosswind, which resulted in a runway excursion and collision with terrain.NTSB WPR20CA166Accident · No injuriesClass 4 · Data collectionFinal reportAviat A 1 · Glendive, MTThe pilot's failure to maintain airplane control during landing in gusting wind condition which resulted in a collision with terrain.NTSB WPR15FA238Accident · 1 fatalField investigationFinal reportAviat A 1 · Compton, CAThe pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…NTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.NTSB ANC12LA113Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Fairbanks, AKThe pilot’s excessive application of brakes during landing, which resulted in a noseover.NTSB CEN12LA587Accident · No injuriesLimited investigationFinal reportAviat A-1 · Rolla, NDThe pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.NTSB LAX08CA006Accident · No injuriesData collectionFinal reportAviat A-1 · Arroyo Grande, CAThe pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.NTSB CHI07CA269Accident · No injuriesData collectionFinal reportAviat A-1 · Kellys Island, OHThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the pole, hangar, and crosswind.NTSB CHI06CA179Accident · No injuriesData collectionFinal reportAviat A-1 · Watervliet, MIThe presence of the deer on the runway which resulted in the pilot taking evasive action leading to the nose-over. A factor was the excessive braking by the pilot.NTSB DEN06CA075Accident · Minor injuriesData collectionFinal reportAviat A-1 · Alamosa, COthe pilot's failure to maintain aircraft control during the departure, resulting in an inadvertent stall.NTSB DEN06LA005Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kaycee, WYthe pilot's improper decision to attempt a go-around and the pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was the hard landing.NTSB ANC05LA117Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe flight instructor's inadequate supervision of the dual student, and his failure to maintain control of the airplane. A factor associated with the accident was the dual student's excessive application of the brakes.NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.NTSB FTW04FA144Accident · 2 fatalField investigationFinal reportAviat A-1 · Harwood, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.NTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.NTSB ANC03LA046Accident · Minor injuriesLimited investigationFinal reportAviat A1 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…NTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.NTSB DEN01FA151Accident · 2 fatalField investigationFinal reportAviat A-1 · Montrose, COthe pilot's intentional abrupt maneuver immediately after takeoff and the subsequent loss of aircraft control. Contributing factors were high density altitude weather conditions, and the airplane improper weight and balance.NTSB ANC01LA014Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe pilot's inadequate compensation for a bounced landing, and failure to maintain directional control of the airplane. A factor in the accident was flat lighting conditions.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.NTSB SEA99LA047Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Emmett, IDThe pilot's failure to maintain aircraft control during a low-altitude maneuver to view a coyote on the ground. A related factor was the pilot's low altitude.NTSB SEA98LA112Accident · No injuriesLimited investigationFinal reportAviat Husky A-1 · Triple R Ranch, MTThe pilot's misjudgment of distance and his failure to initiate a go-around. A factor was the high density altitude.NTSB LAX98GA110Accident · 1 fatalFinal reportChristen Industries A-1 · Lebec, CAThe trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…NTSB ATL98LA042Accident · No injuriesLimited investigationFinal reportAviat A-1 · Clearwater, FLfailure of the pilot to maintain adequate airspeed, while maneuvering to pick up a banner, which led to a stall, loss of altitude, and collision with the water.NTSB IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.NTSB LAX97LA228Accident · No injuriesLimited investigationFinal reportAviat A-1 · Novato, CAthe pilot's inadequate compensation for wind conditions during landing, and his subsequent failure to maintain directional control of the aircraft. The gusty crosswind condition was a related factor.NTSB MIA97WA189Accident · No injuriesForeign investigationAviat A-1 · San Fernando, ArgentinaNTSB SEA96LA190Accident · No injuriesLimited investigationFinal reportAviat A-1 · Worland, WYoverload failure of the landing gear axle, after its design stress limits had been exceeded at some undetermined time.NTSB ANC96LA119Accident · No injuriesLimited investigationFinal reportAviat A-1 · King Salmon, AKThe pilot's inadequate weather evaluation, inadequate compensation for the existing wind conditions, and failure to maintain directional control. A factor associated with the accident was the gusty wind.NTSB ANC96LA064Accident · No injuriesLimited investigationFinal reportAviat A-1 · Togiak, AKThe pilot's failure to remove frost from the surface of the wings and his delay in aborting the takeoff. Factors in the accident were the presence of frost on the wings and a deteriorated climb performance.NTSB FTW96LA068Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Collinsville, OKThe pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.NTSB LAX95LA284Accident · No injuriesLimited investigationFinal reportAviat A-1 · Elko, NVthe pilot's misjudged landing flare, which resulted in a hard landing.NTSB LAX93LA293Accident · No injuriesLimited investigationFinal reportAviat A-1 · Selma, CAthe pilot-in-command's failure to maintain direction control, inadequate compensation for the existing wind conditions, and improper use of the rudder. The pilot's lack of total experience in the accident airplane make and model is a factor in this accident.NTSB SEA92LA093Accident · No injuriesLimited investigationFinal reportAviat A-1 · Arco, IDThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.
Back to Aviat A-1