FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
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' 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' ORDER BY event_date DESC, report_number DESC
Run 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 20120330005499APiper PA-28-161 · Arcola, TXOn March 30, 2012 Piper warrior N800KA departed from pearland regional airport (klvj) and flew to Houston Southwest Airport (kaxh). While on the downwind leg of the traffic pattern for runway 09 at kaxh an engine failure occurred. The student pilot and sole…Accident 20120330005159AHughes 369D · Mccormick, SCThis helicopter involved is a 1980 model Hughes 369D, N868W, serial number 1000800D, registered dah aircraft LLC and operated by rotor blade, LLC, who is a part 133 operator but was operating as a part 91 positioning flight from dalton, Georgia, to aiken,…Accident 20120330005069AArado-Flugzeugwerke FW190 A-5 · Case Grande, AZOn March 30, 2012, about 0911 mountain standard time, a focke-wulf FW-190A airplane, N190DK, sustained substantial damaged during a landing at Case Grande airport (cgz), casa Grande, Arizona. The aircraft departed the runway after touch during landing on the…Incident 20120330004769ICessna 425 · Prescott, AZDuring flight oil was observed leaking behind the spinner on the left engine. Aircraft diverted to prc when local aircraft maintenance provider found loose b nut on engine gear reduction protion of engine power section.Incident 20120330004359IDehavilland DHC-6-200 · Sebastian, FLWitnesses stated that the skydiver came in to low and fast. They further stated that his feet hit the edge of the ditch and he tumbled to the ground. He had severe trauma to the head and a broken leg. [privacy data omitted] Was transported to holmes regional…Incident 20120330003939IBoeing 757-232 · Boise, IDDala, flight 1252 (slc-boi) on 3/30/2012 was on descent into boi. Flight attendant was on duty when they became unconscious in the aisle . The aed was used, cpr was administered. Captain declared emergency. The flight landed without incident and EMT met the…Accident 20120329009859ACessna 172S · Midlothian, TXN480SP upon touchdown experienced immediate veer to the right due to crosswind correction still being applied. Pilot then immediately over compensated to the left to correct, at which time the crosswind of approximately 6 knots got under the left wing and the…Incident 20120329006969IEnsing Dale W RV-6A · Lawrenceville, GADuring landing in a crosswind on runway 25 at klzu, the airplane bounced upon initial contact with the runway. On second contact with the runway, the nose wheel gear strut, which is a tapered rod, flexed aft and downward allowing the nose landing gear strut…Incident 20120329005839IBeech V35 · Belleville, MISolo pilot returned from jackson, MI to home base. Aircraft was cleared by ATC tower to land on rwy 5L. On base-to-final turn, pilot lowered flaps. Aircraft made smooth touchdown with landing gear in retracted position. Damage to flaps, belly skin, antennas,…Incident 20120329005209ICessna 550 · Palm Springs, CAOn desent #2 engine encountered compressor stall. Troubleshot and found both bleed air torque valves inop. Removed and replaced both valves, aircraft returned to service.Accident 20120329005199AIndio, CAThe pilot of a powered parachute departed from an open field in Indio, CA. During the intial climb, the aircraft veered off course, and became entangled in power lines. The powered parachute subsequently came to rest suspended in the power lines and caught…Incident 20120329003959IBeech A45 · Ft Pierce, FLAircraft landed rwy 10 r, nose gear collapsed after normal touch down. Inspection revealed that the retract arm rod end had separated and failed to lock nose gear.Incident 20120329003779IAirbus A321-231 · Minneapolis, MNUs air flight(awe) 56 had a birdstrike during climb out from msp at 4,800 feet @2055 local time. The radome was struck and damaged, causing a vibration. The aircraft circled to burn off fuel and returned to msp @2125 local time.Incident 20120328029199IBoeing 737-73V · Arlington, VAOn March 28, 2012, at 1011 EDT, sun country airlines flight scx 265, a Boeing 737-700 N711SY, was involved in an incident at ronald reagan Washington national airport, VA. (Dca). On taxiing in to gate 1, scx 265 passed in close proximity to an airport fire…Accident 20120328004879ABeech E-55 · Broken Bow, NEAfter loss of both left and right engine power, aircraft was diverted to Broken Bow, municipal airport, Nebraska. The pilot was able to restart the left engine and continued to Broken Bow. Pilot was unable to maintain control of aircraft upon descent, and…Incident 20120328004689ICessna 182T · Mccordsville, INThe pilot was completing a crosswind landing with gusting winds from the right. This pilot acknowledges that upon touchdown he removed the crab, but did not lower the right wing adequately to prevent the aircraft from drifting to the left. The aircraft…Incident 20120328004589IPiper PA-23-250 · New Ulm, TXDeparted uncontrolled airport, after 11 minute of uneventful VFR flight airman entered left traffic, for an anticipated normal landing. Landing check list did not include a visual confirmation that landing gear was down and locked. Slightly higher than normal…Incident 20120328004299IColumbia Aircraft Mfg LC41-550FG · Concord, NCNose gear fork mount bolts sheared and fork/ nose wheel/wheel pants departed the aircraft. Forward lower area of nose gear oleo which the gear fork mounts was ground 50% through the material from contact with the runway. There are several marks on the…Incident 20120328004269ICirrus Design SR22 · Englewood, COOn March 28, 2012, at 1533 MDT, Cirrus SR-22, N75MG, sustained minor damge after runway excursion at Centennial Airport (kapa). The one person on board experienced no injuries.Accident 20120328003989AVans RV-3A · Larchwood, IAAirman had been conducting landings at tea, SD, and was having difficulty controlling the aircraft after landing. Flight instructor on the ground advised the airman to fly to Larchwood, IA, to continue landing practice, due to runway being aligned better to…Incident 20120328003949IHughes Helicopters 369E · Lawrenceville, GAAircraft was departing from Gwinnett County Airport and at approximately 400 feet AGL the pilot heard a loud noise followed by a momentary shudder. The pilot notified the tower that he had a problem and returned to the airport. Upon post flight inspection he…Incident 20120328003769IStinson 108-1 · Cotter, AROn March 29, 2012 at 1145 a Stinson 108, N92779 lost partial power after departure from valley air park, Cotter, AR on a pleasure flight. Visual meteorological conditions prevailed at the time and no flight plan was filed. The aircraft made an emergency…Incident 20120328003629IBeech N35 · Loveland, COBeech N35 bonanza, N6135N, landed gear up and sustained minor damage. Neither pilot on board suffered any injury.Incident 20120327005469IPiper PA-28-181 · Gila Bend, AZWhile taxi to parking, airman mis-judged distance to diesel fuel tank. Wing tip scraped tank causing minor damage.Accident 20120327004519AGarlick Helicopters OH-58C · Mccomb, MSInflight fire occured. The pilot reported shortly after takeoff, while in cruise the helicopter yawed to the left, the cabin filled with smoke, and the engine shutdown. The pilot landed in a field and the fire consumed the helicopter. The initial field…Incident 20120327003919ILake LA-4 · Clewiston, FLAircraft departed immokalee (imm) airport on climb out at 1000 feet experienced engine surging. Turn on fuel boost pump and continued climb to 2000 feet. Was unable to return to imm and decided to set aircraft down on to county road 846 just past crows nest…Accident 20120327003759ACessna 441 · Battle Creek, MIOn March 27, 2012, at 0723 eastern daylight time (EDT), a Cessna conquest, CE-441 airplane, N1212C, was damaged while landing at Battle Creek, w.k. Kellogg airport (btl), Battle Creek, Michigan. The airplane was registered to and operated by bil mar foods…Incident 20120326006069INorth American T-28B · Addison, TXOn March 26, 2012, about 0900 central daylight time, a North American T-28B, N52424, departed Addison Airport (kads), dallas, Texas. The airline transport pilot noticed a slight vibration in the aircraft while transiting over the city of garland, TX. The…Accident 20120326005489APiper PA-22-150 · Crowley, LAPilot attempted to land on a private grass airstrip. The aircraft ended up on its nose, slid down the grass runway then flipped over. Substantial damage to aircraft to include dislocated nose strut. Suspect lack of experience and required training.Incident 20120326004579IPilatus P3 · Ardmore, OKThe pilot was landing on runway 13 at Ardmore airport (adm). He stated that he had a green light and the gear was down and locked. Upon touchdown of the main landing gear, he heard the gear horn "chirp" and then when he lowered the nose the aircaft struck the…Incident 20120326004499IPilatus PC-12/45 · Laurel, MSOn March 26, 2012, the pilot of a Pilatus PC-12, aircraft was returning to Laurel hesler-noble airport (klul). Upon arrival the pilot planned a visual approach to runway 31, weather was VFR. Upon extending the landing gear, the pilot notice the nose gear…Accident 20120326004249AAnderson John H Avid Flyer MK 4 · Waxhaw, NC63 Year old male purchased experimental airplane in February, 2012. The only occupant of his airplane was involved in a fatal accident while attempting a go-around at jarrs airport (N52).Accident 20120325012249AFantasy Air Sro Allegro 2007 · Groveland, FLOn March 25, 2012, N2570C collided with trees following a balked landing. The aircraft was en route from north carolina to Florida for the annual "sun n fun" aviation event. Prior to arrival in lakeland, FL the aircraft attempted a landing at sheets airport…Incident 20120325004709ICessna 425 · Sugar Grove, ILAircraft was taxiing on ramp for departure. As the aircraft approached the departure end of runway, the pilot reported a loss of brakes. The aircraft exited the ramp area into the grass and stopped. No damages or injuries occurred.a repair station inspected…Accident 20120325003609AFurru Donald Jeffrey Skyranger V MAX · Viola, ARThe aircraft attempted a landing in a farm field. During the landing attempt, the aircraft bounced three times and executed an attempted go-around. The aircraft successfully cleared a tree line at the departure end of the field. However, the aircraft failed…Incident 20120325003439IBell 407 · Rockwood, TNPilot heard loud banging sound under aircraft. He made a precautionary landing at Rockwood, TN., cut wires and placed light in cockpit, and continued flight. Minor damage reported. This incident was relayed through principal of certificate in AZ.Accident 20120325003429AStinson 108-1 · Coolin, IDPilot landed on snow covered runway. Snow was wet with a frozen top crust and a depth between eight (8) to ten (10) inches at impact point. The aircraft roll out was approx. 600 ft. at which point the main wheels sunk into the snow enough to arrest the…Accident 20120324017339ACessna 172P · Tampa, FLOn March 24, 2012, at approximately 1715Z, a Cessna 172P, N99087, serial no. 17276400 had a hard landing at the Brooksville / hernando county airport (kbkv), Brooksville, Florida. Meteorological conditions prevailed at the time. No one was injured. Post…Accident 20120324007809AEnbody Frank GY 201 Minicab · Granite Shoals, TXThe aircraft operated by frank Enbody was on a 14 CFR 91 pleasure flight. The aircraft lost power and crashed in the yard of a residence. Of the two persons on board the pilot sustained fatal injuries and the passenger sustained severe injuries. The aircraft…Accident 20120324006679APiper PA-28-180 · Margaret, ALPilot departed from talladega airport (kasn) for a local flight. After about thirty minutes the engine quit and the pilot selected the left tank. After several attempts the engine would not restart the pilot selected the right tank again. The engine did not…Accident 20120324006349ACessna T337B · Dothan, ALThe pilot was unable to get the gear down and locked. After trying for an hour the pilot was able to get the gear up and locked. The pilot made a gear up landing on the grass between the taxiway and runway. The rear propeller struck the ground during the…Accident 20120324005129ACessna 172P · United States A, COOn departure from runway 34R with a reported crosswind, the pilot could not maintain flight after takeoff rotation. Pilot attempted to gain more airspeed with nose down input. Aircraft contacted the ground in the grass area ajacent to runway 34R. Pilot…Accident 20120324005099AHall Jeffrey Hall RV-4 · Calhan, COAircraft N605RV piloted by sole occupant [privacy data omitted], completed a successful landing to the south at CD23 Aero Bear Field in Calhan co with a crosswind component, during rollout aircraft received a wind gust that induced a left drift, brakes were…Accident 20120324004659AJacobs Richard RV6A · Bow, WAPilot stated that he had been flying for approximately 2 hours on the day of the accident. After doing several touch and go landings at a nearby airport, the pilot reported that he was in cruise flight when his engine stopped operating. He tried to restart…Incident 20120324004399IHawker Beechcraft C90GTI · Fort Lauderdale, FLOn March 24, 2012, at approximately 16:52 hours aircraft Beechcraft C-90, N203BK, s/n LJ-1988 declared an emergency at the Fort Lauderdale international airport (kfll). The aircraft was on a 14 CFR 91 flight from kfll to monroe regional airport (kmlu).…Accident 20120324004329ACessna 172R · Council Bluffs, IAPrior to landing, the pilot stated he prematurely flared and the plane ballooned. He tried to recover the aircraft, the plane struck the runway, porpoised three times,veered off the runway, and struck a runway light.Accident 20120324003909ANew Kolb Mark 3 Classic · Deland, FLThe plt rptd that he was returning to land on rwy 23, after a one hour local flight. As he completed a left turn from base to final, the engine sputtered then quit. He then elected to deploy the acft ballistic parachute system instead of attempting an engine…Incident 20120324003899ICessna P210N · Crystal River, FLOn March 24, 2012, at 1300 EDT, a Cessna P-210N, N4786K, registered to irvin-kaesair LLC, made a hard landing at the Crystal River airport, Crystal River, Florida, while on a 14 CFR part 91 personal flight. Visual meteorological conditions prevailed at the…Incident 20120324003789IMaule M-5-180C · Fayette, OHAirman landed above aircraft in the middle of a wet, unapproved field and was unable to stop before reaching a plowed section. As aircrfat departed the grass field and onto the plowed section, the main wheels had sunk into the mud which caused the aircrft to…Accident 20120324003739ASmith Aerostar 601P · Castroville, TXThe FAR 91 IFR flight originated from kaxh with intended destination of kcvb. During the first approach to kcvb, pilot stated he was to FAR to the right of center-line runway 15 and decided to abort and perform a left circle to land manuever. During the…