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 ('0540102')
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 ('0540102')
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 CEN25LA264Accident · No injuriesClass 4 · LimitedFinal reportAlon A2 · Pipestone, MNThe failure of the left brake to release due to corrosion and pitting of the caliper piston and bore, which resulted in a runway excursion.NTSB WPR22LA050Accident · Serious injuriesClass 4 · LimitedFinal reportAlon A2 · Frazier Park, CAThe pilot’s failure to maintain adequate airspeed while on approach for landing which, resulted in an aerodynamic stall and collision with terrain.NTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.NTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.NTSB ERA14LA208Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Apex, NCA total loss of engine power during initial climb for reasons that could not be determined during postaccident examination and testing.NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.NTSB WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB LAX08CA186Accident · No injuriesData collectionFinal reportAlon A2 · Sandpoint, IDThe airplane struck a deer on the runway while performing touch-and-go landings. Contributing to the accident was the dusk light condition.NTSB CHI07LA096Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Ravenna, OHThe pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.NTSB ATL04LA100Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Fort Pierce, FLThe loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.NTSB LAX04FA168Accident · 2 fatalField investigationFinal reportAlon A2 · Cameron Park, CAThe pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in a stall/spin. Also causal was the partial loss of engine power due to improperly secured magnetos.NTSB CHI04LA082Accident · No injuriesLimited investigationFinal reportAlon A2 Ercoupe · Hawley, MNThe loss of engine power for undetermined reasons. A contributing factor was the fence post.NTSB ANC03FAMS1Accident · 2 fatalMissing aircraftFinal reportAlon A-2 (Aircoupe) · Ketchikan, AKUndetermined. .NTSB CHI00LA086Accident · Minor injuriesLimited investigationFinal reportAlon Ercoupe · Osceola, IAfuel starvation due to an undetermined blockage in the fuel line from the header tank to the gascolator. Factors relating to this accident were the blocked fuel line and the rough terrain.NTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.NTSB SEA95FA136Accident · 1 fatalField investigationFinal reportAlon Aircoupe A-2 · Cody, WYThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course. A factor was the downdrafts encountered in the mountainous terrain.NTSB NYC95LA024Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Goode, VAthe inadequate preflight by the pilot, resulting in engine failure due to water ingestion.NTSB LAX94FA367Accident · 1 fatalField investigationFinal reportAlon A2 · Orland, CAthe pilot's intentional performance of an aerobatic maneuver which overloaded the outboard portion of the left wing and caused it to fail. Factors which contributed to the accident were the pilot's overconfidence in his ability to perform the maneuver and his…NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.NTSB LAX91LA290Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Trinity Center, CAThe pilot's failure to ensure an adequate supply of fuel was available. Contributing to this accident was soft terrain.NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.NTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…NTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…NTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…NTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…NTSB FTW85FRD01Accident · Serious injuriesFinal reportAlon A-2 · Bunkie, LAThe acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…NTSB MIA84LA249Accident · No injuriesLimited investigationFinal reportAlon A2 · Vero Beach, FLThe acft collided with mail boxes during a forced landing after the engine failed. The plt said he lost all engine powerwhile climbing through 1800 ft AGL. Post crash inspection of the engine revealed that the gasket on the fuel transfer pump bowl had failed.…NTSB LAX83LA379Accident · No injuriesLimited investigationFinal reportAlon A2 · Afton, CADuring an aerial observation mission, the passenger became ill, so the plt elected to land on a hard-packed strip across a plowed field. After landing, he walked over the area. Except for a rut at about midfield, he perceived there would be no problem in…NTSB FTW82DA305Accident · No injuriesFinal reportAlon A2 · Poyen, ARAs the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…NTSB DEN78FQA37Accident · Minor injuriesClosedAlon A-2 · Albuquerque, NMNTSB MKC77DCG44Accident · No injuriesClosedAlon A2 · Grant City, MONTSB NYC77FGM21Accident · No injuriesClosedAlon A-2 · Beaver Falls, PANTSB FTW77FRA09Accident · No injuriesClosedAlon A2 · North Zulch, TXNTSB NYC76FHD16Accident · No injuriesClosedAlon A-2 · Ocean City, NJNTSB LAX76AL030Accident · 2 fatalClosedAlon A-2 · Grapevine, CANTSB CHI76DET10Accident · No injuriesClosedAlon A2 · Logansport, INNTSB NYC75AN109Accident · 2 fatalClosedAlon A-2 · Vineland, NJNTSB OAK74DVA72Accident · No injuriesClosedAlon A-2 · Fresno, CANTSB MIA74AM010Accident · 2 fatalClosedAlon A-2 · Blue Springs, MSNTSB LAX73FUJ87Accident · No injuriesClosedAlon A-2 · Glendale, AZNTSB CHI73FET06Accident · Minor injuriesClosedAlon A2 · Ligonier, ILNTSB CHI73FER03Accident · Minor injuriesClosedAlon A-2 · Elk Mound, WINTSB OAK72AP044Accident · 1 fatalClosedAlon A-2 · Central Vly, CANTSB CHI72DET24Accident · No injuriesClosedAlon A-2 · Mentone, INNTSB NYC72FKM21Accident · Serious injuriesClosedAlon A-2 · Boone, NC
Back to Alon A2