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 ('2210405')
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 ('2210405')
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 WPR24LA316Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1A · Taft, CAThe pilot receiving instruction’s failure to maintain directional control during landing roll and the flight instructor’s delayed remedial action.NTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…NTSB CEN22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1A · St. Jo, TXThe total loss of engine power due to carburetor icing during cruise flight, which resulted in a forced landing and impact with terrain.NTSB WPR20CA093Accident · Minor injuriesData collectionFinal reportAviat A1 · Columbia, CAThe pilot's failure to maintain bank control during landing in gusting wind conditions.NTSB GAA19CA432Accident · Minor injuriesData collectionFinal reportAviat A1 · Ennis, MTThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's distraction due to looking at wildlife.NTSB WPR13CA280Accident · Minor injuriesData collectionFinal reportAviat A-1A · McCall, IDThe pilot’s failure to maintain adequate airspeed while on approach for landing, which resulted in a loss of airplane control and a hard landing.NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN09CA357Accident · No injuriesData collectionFinal reportAviat A1 · Garrison, MNThe pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.NTSB CEN09CA352Accident · No injuriesData collectionFinal reportAviat A-1A · Marfa, TXThe pilot's failure to maintain control while landing in gusty winds.NTSB DFW07LA105Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Farmingdale, NYThe pilot's failure to maintain control of the airplane during a short-field takeoff, which resulted in an inadvertent stall.NTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.NTSB DEN06CA078Accident · No injuriesData collectionFinal reportAviat A-1A · Englewood, COthe pilot's failure to maintain aircraft control while taxiing from landing, resulting in a collision with a refuse dumpster. A contributing factor was his physical impairment by alcohol.NTSB SEA06CA043Accident · No injuriesData collectionFinal reportAviat A1-A · Pine, IDThe pilot's failure to maintain clearance from terrain while maneuvering. Snow covered terrain and flat light conditions are contributing factors.NTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB IAD04IA032Incident · No injuriesIncident investigationFinal reportAviat A-1A · Fryeburg, METhe pilot's improper use of carburetor heat, which resulted in a loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB LAX04LA297Accident · No injuriesLimited investigationFinal reportAviat A-1A · Visalia, CAthe pilot's failure to maintain an adequate airspeed on final approach, which resulted in an inadvertent stall and a hard landing.NTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.NTSB SEA03FA096Accident · 1 fatalField investigationFinal reportAviat A-1A · Sandpoint, IDThe pilot's failure to maintain adequate airspeed during a low pass maneuver which resulted in a stall. A related factor was the trees.NTSB ATL03LA035Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control during landing roll which resulted in a loss of control and collision with a ditch. A factor was separation of the spring clip from the landing gear steering system.NTSB LAX01LA175Accident · No injuriesLimited investigationFinal reportAviat A-1A · TontoNat.Forest, AZThe pilot's inadequate crosswind correction compensation during landing and his failure to maintain proper alignment with the usable runway. A contributing factor was the presence of bushes in proximity to the airstrip.NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.NTSB MIA98LA190Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Daytona Beach, FLThe pilot's failure to maintain airspeed, which resulted in a stall. A contributing factor was the pilot's delay in initiating remedial action.NTSB FTW98LA110Accident · No injuriesLimited investigationFinal reportAviat A-1 · Buena Vista, COThe pilot's failure to maintain directional control of the airplane. Factors were the crosswind changing to a tailwind, and the pilot's lack of experience in the type of aircraft.
Back to Aviat A-1A