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 ('5110302')
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 ('5110302')
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.
Incident 19791126045569IConaer LA4 · Gorman, TNAircraft received minor damage during takeoff from pasture, where pilot landed when out of fuel.Accident 19791116032459AConaer LA4 · Groton, CTPilot said hatch came open during water takeoff. Tried to secure right wing float,hit wave. Water looped aircraft.Accident 19790420043129AConaer LA4 · Jonesboro, MEPilot delayed goaround and aircraft crashed into trees at end of runway.Accident 19781202042879AConaer LA4 · NJAccident 19781008035349AConaer LA4 · Tuckernuck Isl, MAR main gr failed.Accident 19781008031409AConaer LA4 · Harding Lake, AKContacted brush off side of runway.Incident 19780913017339IConaer LA4 · Gainesville, FLNose gear collapsed on roll out. Hydraulic flex line had ruptured.Accident 19780806022639AConaer LA4 · Lexington, SCPlt stated tkof with full up trim setting.Accident 19780630019059AConaer LA4 · San Antonio, TXPerforming step taxi maneuvers. Amphibious. Misc-nose gr door opned for undetermined reasonIncident 19780625035989IConaer LA4 · Dillon, MTAirplane touched down in a drift, collapsing the main strut (left) that touched down first.Incident 19780513033659IConaer LA4200 · Houston, TXLanded short of runway after running out of fuel.Accident 19780314010829AConaer LA4 · Pierson, FLAccident 19780109008569AConaer LA4 · Hawthorne, NVVFR flt not rcmmdd,tph wx. Mtns obscured,hit mtn abt 6700FT MSL.rery date 2/6/78.Accident 19761222039699AConaer LA4 · San Antonio, TXHit road curb.Accident 19760806023779AConaer LA4 · Derry, NHUn clb abv trees aftr tkof,atmtd rtrn to lake. Acft stalled in turn.Accident 19751123037549AConaer LA4 · Angola, INR wing float ctctd water,plt lost ctl.Accident 19751011033779AConaer LA4 · Alderwood Mnr, WAHeavily loaded acft,unable to clr obstructions.1700FT rwy. Tkof performance info not avail fm manufAccident 19750917031659AConaer LA4 · Long Beach, CANose gr doors open. Ip let student make ldgAccident 19740611023489AConaer LA4 · Jacksonville, FLFlared out abt 25FT hi,dscndd in a slightly nose hi attitude. Plt attn diverted to hyd motor.Accident 19740527014619AConaer LA4 · Petersburg, AKParking brakes set.Accident 19731027036099AConaer LA4 · Norwood, MAOtr plts expd brake fade drg taxi back to tiedown brakes ckd ok. Greasy residue found on brake discAccident 19730731027369AConaer LA4200 · Azle, TXAcft sank,not recovered.Accident 19730722022479AConaer LA4 · Bethel, MEOn touchdown nose dug into water left float broke off. Aircraft sank.Accident 19730511012389AConaer LA4 · St Charles, MOWater very smooth.t/d on acfts keel,skipped aprx 4-6IN into air then settled back. Acft sank.Accident 19730325013979AConaer LA4 · Key West, FLWater rudder not extdd bfr ldg. Nose and r wing of acft hit pier. Wind gusting 25K.
Back to Lake LA-4