Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('1181508')
ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('1181508')
ORDER BY event_date DESC, report_number 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.
Accident 19740711017509ABell 206A · Allentown, PADuring an attempted rearward tkof plt misjudged gnd clnc. Dmgd gr attach points.Accident 19740705024919ABell 206A · Reno, NVSling load operation with high downslope wind cond. Da abt 10500FT.vert tkof,turned r for east dep.Accident 19740625042339ABell 206A · Blairsville, GAAcft drifted r after t/d.hinged sign struck by m/r blades.Accident 19740623022259ABell 206A · AKAccident 19740621018849ABell 206A · Brooklyn, NYEngine power loss due to water ingestion. Inflatable floats mounted on skids.Accident 19740318005619ABell 206A · Grnd.Canyon, AZSnow crust collapsed under right skid. Snow survey flt.Accident 19740308004959ABell 206B · Gloria, LAFlew into river drg apch to heli pad.Accident 19740108002209ABell 206A · Venice, LAUn cont in fog,attmptd water ldg. Skids with pop-out floats. Pax presumed fatal. Wea brief by co.Accident 19731202039409ABell 206A · North Platte, NEPractice hover,when decreasing rotor RPM discovered apld full pwr acft turned 180 deg. Skids failedAccident 19731120039179ABell 206A · Intrcstl Cty, LARetarded inflation of r emerg float,rolled over. Helo sank.Accident 19731120038941ABell 206A · Webster, PAM/r blades seprtd aft hitting Cessna.Accident 19730918033199ABell 206B1 · Beltsville, MDImproper autorotation proc.Accident 19730807028879ABell 206B1 · Wasilla, AKHit partially concealed wires. FAA plt in FAA rental acft.Accident 19730728025999ABell 206A · DhahranSevere spike knock.Accident 19730728024319ABell 206B1 · New York, NYPossibly 1st flt fm l seat. Made steep r turn followed by rapid descent to water.Accident 19730527015189ABell 206A · Honolulu, HIHit pwr lineAccident 19730322004689ABell 206A · Rimersburg, PAAfct struck ground hard tail first. Owner requested pilot to demonstrate autorotation dscnt.
Back to Bell 206A