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 ('0970101', '0970113', '0970114')
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 ('0970101', '0970113', '0970114')
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 WPR22FA026Accident · 1 fatalClass 3 · FieldFinal reportAyres S-2R · Shafter, CAThe pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB GAA19CA271Accident · No injuriesData collectionFinal reportAyres S 2R · Stuttgart, ARThe pilot's exceedance of the airplane's critical angle of attack while maneuvering during an agricultural application flight, which resulted in an aerodynamic stall.NTSB GAA16CA451Accident · No injuriesData collectionFinal reportAyres S 2R · Cordele, GAThe pilot’s failure to maintain clearance from power lines during an agricultural application flight while flying toward the sun.NTSB WPR10LA247Accident · No injuriesLimited investigationFinal reportAyres S2R · Glenn, CALoss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.NTSB CEN09LA297Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Monroe, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.NTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.NTSB SEA06CA117Accident · No injuriesData collectionFinal reportAyres S-2R · Grand View, IDThe pilot's inadvertent reduction of turbine engine power to the reverse position while landing on a desert road. A factor was the fence adjacent to the road.NTSB DFW05CA173Accident · No injuriesData collectionFinal reportAyres S-2R · Eagle Lake, TXThe pilot's failure to maintain directional control during landing.NTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.NTSB LAX04CA154Accident · Minor injuriesData collectionFinal reportAyres S-2R · Los Banos, CAthe pilot's failure to maintain proper runway alignment due to visual restrictions from the light condition, resulting in a nose over. Factors in the accident were the dusk light conditions and sun glare.NTSB CHI03LA297Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eudora, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the trees and the ditch which the airplane contacted during the forced landing.NTSB LAX01LA078Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Holtville, CAThe pilot's failure to maintain clearance from the wires. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB IAD01LA026Accident · No injuriesLimited investigationFinal reportAyres S2R · Crewe, VAthe loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.NTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB LAX98LA238Accident · No injuriesLimited investigationFinal reportAyres S2R · Shafter, CAThe pilot's failure to maintain an adequate clearance from the irrigation standpipe due to glare from the rising sun.NTSB FTW98LA259Accident · No injuriesLimited investigationFinal reportAyres S2R · Watson, ARThe partial loss of engine power due to the disconnection of the propeller governor control as a result of the stripped threads on the propeller governor control push-pull rod. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97WA158Accident · 1 fatalForeign investigationAyres S2R · Brenon, PanamaNTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…NTSB SEA96LA113Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Aberdeen, IDpilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…NTSB CHI96LA119Accident · No injuriesLimited investigationFinal reportAyres S2-R · Wyatt, MOthe pilot's failure to maintain control of the airplane during takeoff. A factor was the crosswind condition.NTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.NTSB MIA94LA191Accident · No injuriesLimited investigationFinal reportAyres S2R · Ruleville, MSThe pilot-in-command's misjudgement of his altitude while maneuvering on an aerial application/swath run, resulting in an in-flight collision with terrain and subsequent nose over.NTSB LAX94LA143Accident · No injuriesLimited investigationFinal reportAyres S2R · Winterhaven, CAA loss of engine power for an undetermined reason.NTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.NTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.NTSB LAX91LA331Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Visalia, CAA loss of engine power due to the failure of the master rod to the number one cylinder resulting from a lack of oil.NTSB LAX89LA202Accident · 1 fatalLimited investigationFinal reportAyres S2R · Atlantic Ocean (Atlantic Ocean)The pilot's continued flight from VMC to IMC, with icing conditions, from which recovery was not successful.NTSB LAX89DVA01Accident · Serious injuriesFinal reportAyres S2R · Traver, CAWhile spraying a cotton field the engine lost power. The pilot executed a forced landing in an open area but rollout continued into crops. The acft nosed over. Investigation revealed only unuseable fuel on board.NTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…NTSB LAX88DVA12Accident · No injuriesFinal reportAyres S2R · Kerman, CADrg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire.NTSB FTW86LA111Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Liverpool, TXThe pilot was involved in a aerial application flt when the acft stalled during a turn. The pilot stated he had too much weight to execute the turn at the airspeed selected. The airspeed was aprx 10 KTS above stall speed at the time of the downwind turn. He…NTSB MIA86LA175Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Graceville, FLA witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he…NTSB BFO86FID06Accident · Minor injuriesFinal reportAyres S2R · Virginia Beach, VAThe acft was ditched after a loss of power during takeoff. Plt was unable to maintain alt & dumped liquid fertilizer load prior to landing. After ditching in a shallow canal the acft nosed over. Post accident investigation revealed a cracked cylinder in the…NTSB MKC84LA242Accident · No injuriesLimited investigationFinal reportAyres S2R · Rohwer, ARThe plt was unable to maintain alt after the engine failed. A forced landing was made in a field covered with 4 to 6 ft tall weeds. The acft traveled sideways during the landing. After the accident, the plt observed a broken rod which had penetrated the…NTSB MKC84LA152Accident · No injuriesLimited investigationFinal reportAyres S2R · Wilmot, ARPlt stated a loss of pwr occurred shortly after takeoff at an alt of 100 ft AGL. The acft nosed over during the forced landing. Inspection of the engine revealed no pre-impact failue/malfunction.NTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…NTSB FTW83LA432Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Bay City, TXDuring a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly…NTSB LAX82DUJ45Accident · No injuriesFinal reportAyres S2R · Goodyear, AZThe aircraft had just been loaded with spray material. The pilot stated that after taking off, he leveled off over cotton at the end of the strip and made a power reduction. At about that time, the aircraft settled into the cotton and hit an embankment. The…NTSB FTW82DA236Accident · No injuriesFinal reportAyres S-2R · Edgerly, LAAfter takeoff with a load of fertilizer, the aircraft lost power and a forced landing was made which resulted in damage to the aircraft. The cause of the engine malfunction was not determined.NTSB ATL82DA105Accident · Minor injuriesFinal reportAyres S2R-600 · Evergreen, ALThe pilot stated that about 5 minutes after takeoff the engine skipped once, popped, then quit completely with no other warning. The aircraft was over a wooded area and was forced to land in the trees. It was determined that the aircraft was approximately 740…NTSB LAX82DA137Accident · No injuriesFinal reportAvres S-2R · Kettleman City, CAThe pilot stated that the fuel gauge was faulty so he flew by time. On the day of the accident the battery on the pilot's electric watch ran down. The pilot reported that the aircraft ran out of fuel and crashed in an open field with his watch still showing…NTSB DEN82FTA04Accident · Minor injuriesClosedAyres S2R · Richey, MTNTSB ATL81FKJ27Accident · No injuriesClosedAyres S2R · Ft Mitchel, ALNTSB LAX81DUJ76Accident · No injuriesClosedAyres S2R · Gila Bend, AZNTSB FTW81DRJ17Accident · No injuriesClosedAyers S2R · Jonesville, LANTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARNTSB ATL81FKQ11Accident · 1 fatalClosedAyres S2R · Hollandale, MSNTSB LAX80FVA66Accident · No injuriesClosedSnow 600S2R · Lemoore, CANTSB LAX80FVA62Accident · No injuriesClosedAyres S2R · Kerman, CA
Back to Ayres S-2R