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 20100616035249AGrumman ACF G-164B · Mayfield, KYThe pilot was performing required 14CFRPART 137 agricultural pilot knowledge &skill test for certification. When demonstrating the landing portion of the test, the aircraft touched down on runway 36 at M25 with what appeared to be an excessive rate of descent…Incident 20100616034969IBeech 36 · Bremerton, WAOn June 16, 2010, N789JH, owned and operated by [privacy data omitted] received minor damage after a gear up landing at the Bremerton airport, Bremerton Washington. The pilot stated in a written statement, "made routine left downwind for runway 19 at…Incident 20100615036332ISchempp-Hir Ventus 2CT · Parowan, UTOn Tuesday June 15, 2010 at 1533 mountain daylight time, N455S a schleicher alexander gmbh & co. model ash 26 e glider piloted by [privacy data omitted] and N514TW a Schempp-hirth model ventus 2CT glider piloted by [privacy data omitted] were involved in a…Accident 20100615036242ASchleicher ASH 26 E · Parowan, UTOn Tuesday June 15, 2010 at 1533 mountain daylight time, N455S a Schleicher alexander gmbh & co. model ash 26 e glider piloted by [privacy data omitted] and N514TW a schempp-hirth model ventus 2CT glider piloted by [privacy data omitted] were involved in a…Incident 20100615035629IBeech G18S · Napakiak, AKAs aircraft settled onto the runway for landing, landing gear collapsed. Aircraft sustained damage to the propellers and minor damage to the flaps.Incident 20100615034919IPiper PA-31T · Sioux City, IAOn June 15, 2010, at approximately 08:04 CDT, a Piper (PA-31T) landed gear up on runway 031 at the Sioux City, IA airport (sux). The aircraft departed sheldon, IA bound for omaha, NE. On approach, the pilot selected gear down but did not get proper gear…Accident 20100614050329AAir Tractor AT-602 · Mccrory, AROn June 14, 2010, Air Tractor AT-602, N4257R was being operated near Mccrory, Arkansas, in visual meteorological conditions under 14CFR, part 137. The aircraft received minor damage when the aircraft engine lost power and the aircraft impacted an irrigation…Accident 20100614048799ARans Coyotte II · Lincoln, CAThis accident occurred in the traffic pattern foot print of Lincoln regional (lhm) airport Lincoln, CA. This was a FAR 91, personal local flight with one pasenger. The aircraft has a special airworthiness certificate in the experimental category for the…Incident 20100614043459IPiper PA-28R-201T · Liberty Hill, TXOn June 14, 2010, during takeoff from the Burnet Airport at approximately 5500 MSL the engine lost power. An emergency landing, with the gear up, was executed into a cornfield near Liberty Hill, TX. All three occupants were not injured. Because of the corn…Incident 20100614038449IPiper PA-42-720R · Jacksonville, FLAircrat N9142B landed with nose wheel retracted causing minor damage to aircraft.Accident 20100614035689AAir Creatio GTE · Springville, UTThe aircraft took-off from a baseball field behind a junior high school. On the climb out after departure, just shortly after rotation, the aircraft struck the power lines and shortly after the aircraft impacted the ground. The aircraft was distroyed and the…Accident 20100614035009AStinson 108-1 · Townsend, MT[privacy data omitted] Said that it was a clear day with no wind. He intended to make one takeoff, traffic pattern, and landing. He stated the touchdown on landing was good. On rollout he applied the brakes and must have over applied the brake on one side,…Accident 20100614034669APiper J3C-65 · Hot Springs, AR[privacy data omitted] In command of J-3 cub N70906, inadvertantly shut off fuel, intending to add carburetor heat. This occurred on short final for landing at Hot Springs. Engine starved of fuel, stopped running and cause was not discovered until after…Incident 20100614034619IHughes 369D · Mt. Pleasant, TNThe pilot stated he was hovering for the lineman to make wire splices on a powerline. He had a slight quartering tailwind. The powerline had an oscillation as lineman was disconnecting from it, at the same time the tailwind moved the tail rotor closer to the…Incident 20100614006129IBell 407 · Fargo, NDDuring cruise/low approach to hospital helipad approximately 4 miles out the pilot windshield failed losing 90% of the window. Investigation by company personnel revealed a dent in the windshield metal trim just forward of the pilot door. The dent was about…Incident 20100614006119ICessna 172P · Columbus, OHThis incident occurred during the second touch and go being conducted by a student pilot on his first solo flight. The pilot was cleared for a touch and go on runway 27R by the tower at osu. He landed approximately 1/3 of the way down the runway from the…Incident 20100614005289ICessna 182P · Concord, CAOn 06/14/2010, at apprx 1535, Cessna aircraft N1055M, serial number 18264217, pilot reported windshear on landing at the Concord airport runway 19R. Pilot landed the aircraft hard blowing the nose landing gear tire causing minor damage to the aircraft nose…Accident 20100613048789AGrumman ACF G-164B · Davis, CAPilot aparently hit the ground while dusting. The aircraft main landing gear hit the water/ground and flipped over on its back.Incident 20100613043469IPiper PA-32R-301 · Addison, TXOn June 13, 2010, at approximately 1730 CST, a Piper saratoga PA-32R-301 airplane, N8147A, sustained minor damage when the nose gear collapsed during the takeoff roll while departing from the Addison Airport (kads) in Addison, TX. The sole occupant of the…Accident 20100613041729ABell 47G-2 · Plymouth, MIOn June 13, 2010 at approximately 1650 inspector [privacy data omitted] received a call from inspector [privacy data omitted] requesting response to a helicopter accident on the 275 just north of ann arbor road. Inspector [privacy data omitted] was briefed…Accident 20100613037079APiper PA-28-181 · Empire, AROn June 13, 2010, at 0930 CST, a Piper PA28-181, N6076H, registered to [privacy data omitted] dba, [privacy data omitted]. Aircraft lost left wing while on a pleasure flight, aircraft impacted ground. Visual meteorological conditions prevailed at the time. No…Accident 20100613037039ABaby Ace Ho Home Built · Wilmington, NCAircraft touched down on runway. Pilot applied power to perform a "go around". The aircraft began a left turn and hit the top of a tree with the left wing leading edge. The aircraft traveled approximately 300 yards beyond the tree and impacted the ground nose…Accident 20100613036809ACessna C208 · Felipe CarrillThe investigation is being conducted by the government of Mexico. The NTSB has assigned an accredited representative to assist the investigation under the provision of ICAO annex 13 as the state of manufacture. The federal aviation administration, Cessna and…Accident 20100613035969ABeech A36 · Lidderdale, IANote: pilot's log is unavailable and presumed lost in the crash. The pilot departed algona, IA (axa) with one passenger. His desination was lamar, MO. (Llu). Approxiately 1 mile west of Lidderdale, IA the aircraft impacted the ground at high speed at a steep…Incident 20100613035889IPiper PA-28R-180 · Grain Valley, MOThe aircraft landed gear-up on runway 27. The pilot in command made contact with the Kansas city FSDO and informed the office that the landing gear had collapsed for no apparent reason during the landing roll-out. The aircraft sustained minor damage to the…Incident 20100613035809ICessna 172On 06-13-2010 at approximately 8:30 am during the landing rollout at Sulphur Creek Ranch the aircraft lost directional control. The aircraft swerved to the left and the nose gear went into a hole just off the left side of the runway. The nose gear collapsed…Accident 20100613035709ACessna B188B · Blackfoot, IDLanded on runway 19 at Blackfoot, Idaho. At arrpximatly 1200' from the end of the runway the aircraft veered right. The pilot stated that there was a violent shimmy. The pilot tried to gain control of the aircraft but was unable. The aircraft came to rest…Accident 20100613005259AWaco UKC-S · Seattle, WAOn 06/13/2010 at approximately 18:20 PDT a Waco Ukc-S aircraft, serial number 3978,owned by [privacy data omitted] lost control during landing at the Boeing field international airport (kbfi) in Seattle Washington causing damage to the aircraft. The pilot and…Accident 20100612039289ABeech 1900D · Denver, COOn June 14, 2010, glba director of ops reported:this part 91 reposition flight was to be operated from den to cys it returned to land in den. The crew reported a normal preflight and takeoff to the flight, until they selected the gear up. When the gear handle…Accident 20100612036949ACessna 170 · Campbellsville, KYOn June 12, 2010, at 9:01 p.m. eastern daylight time, Cessna N4273V was substantially damaged when it impacted terrain after a loss of directional control while landing at the Campbellsville (Taylor County) Kentucky airport (aas). The certificated private…Incident 20100612035659IBoeing 737-3H4 · Omaha, NEAircraft was in cruise flight at flight level 370 when "cabin altitude warning" horn sounded. Cabin was at 10,000 feet and was unable to restore cabin altitude. Maximum cabin altitude was 12,000 feet. Emergency descent initiated with manual control. No other…Incident 20100612035649IBoeing 737-3H4 · Omaha, NEAircraft was in cruise flight level at FL 370, then experienced a "cabin altitude warning" horn. Cabin altitude was climbing through 10,000 feet at approximately 1000-2000 feet per minute. Accomplished cabin altitude warning checklist and cabin was still…Incident 20100612035089ILearjet 45 · Fort Lauderdale, FLCrew experienced autopilot malfunctionafter departure from fll. Crew decided to turn back and return to fll. Aircraft taken to Bombardier CFR 145 repair station where diagnostics revealed subsystem line replaceable unit failure as being isolated to the hsta…Accident 20100612035029AMcculley Ro Wittman TAI · Lamoni, IAPilot attempted a take off in an overweight condition. The aircraft failed to reach appropriate speed for take off. Pilot aborted, ran off the end of the runway and the aircraft flipped over as it ran through tall grass. Passenger was injured. Pilot was…Incident 20100612034899ICessna 172N · Windsor Locks, CTAircraft N733YR was on an IFR practice approach to runway 33 at bdl. While on 1/2 mile final the pilot asked for another practice ILS approch to runway 33. The pilot was given climb instructions. The pilot advised "we have a problem with power and need to…Incident 20100611041759ICessna 150K · Bolingbrook, ILA banner tow cable and hook separated from N643G while on left base to runway 18 at 1C5 and penetrated the roof of 1025 chuchill drive Bolingbrook, Illinois 60440. No damage was caused to N643G. No accident or injuries to persons ensued. The banner tow…Accident 20100611037789ACirrus Desi SR20 · Perry, NYOn 06/11/2010 a Cirrus SR20GT, N800GT,departed runway 28 at Perry Warsaw Airport, NY,01G,1700EDT. The [privacy data omitted] [privacy data omitted], sustained no injuries. Minor property damage, two runway endlights were taken out. Winds were variable,VMC…Accident 20100611037699APiper PA-32R-300 · Eagar, AZOn June 11, 2010, about 1354 mountain standard time, a Piper PA-32R-300, N7699F, was destroyed when it impacted a building near Eagar, Arizona, during takeoff initial climb from the Springerville municipal airport (D68), Springerville, Arizona. The airplane…Incident 20100611036799IDean George Dean/Pitts · Burlington, NCThe pilot, [privacy data omitted] stated "on earlier flights and taxi tests I had experienced a shimmy from the tail-wheel assembly. I lubed and verified all connections were attached properly/securly. I performed 5-6 high speed taxi tests without any shimmy…Accident 20100611036239ABurkhart GR G103C Twin · Sutcliffe, NVSubsequent to takeoff from a dry lake bed with an aero tow, the pilot intentionally released at about 1500 feet AGL. The pilot stated that he was unable to obtain the lift needed to clear the terrain and proceed to his destination airport (NV23) located about…Accident 20100611035469ACessna 170B · Wasilla, AKAfter landing at Wolf Lake the pilot taxied to the end of runway 36 for an 18 departure. When the pilot reached the end of the runway, a wind gust pushed the airplane around into a ground loop. The pilot stated that the wind wasn't that bad, he just didn't…Incident 20100611034929ICessna 177RG · North Las Vegas, NVAircraft landed gear up on runway 25, North Las Vegas Airport (vgt), 2 POB, no injuries. Nose gear failed to extend upon initial landing approach to vgt, rwy 12R, pilot requested flyby tower to verify non-extension of nose gear to verify gear indicator light…Incident 20100611005989INational Ba 755-12 · Madison, OHAircraft was landing in a field and the drag rope became tangled for a brief moment with a fence. The gondola rocked and one of the passenger not holding on departed the aircraft prior to landing. Passenger fell about 5 feet from the gondola and was taken to…Incident 20100610039039ICessna R182 · Atlantic City, NJOn June 10, 2010 about 1750 eastern daylight time, a Cessna R182 airplane, N1765R, was damaged upon landing on runway 13 at Atlantic City international airport (kacy), Atlantic City, new jersey. The private pilot and the certified flight instructor were not…Incident 20100610036659IPiper PA-44-180 · Frederick, MD06/10/10THE mechanic for Frederick flight school called to tell me that their multi engine training aircraft struck deer while on take-off . Instructor stated that while on take-off roll 2 deer ran into the path of the aircraft. The smaller of the 2 deer was…Incident 20100610036269IDassault-Br Falcon 50 · Broomfield, COAircraft took off from kbjc enroute to tulsa, OK, when it encountered hail at FL240 - FL260. Upon landing at ktul, aircraft was inspected by local maintenance facility and a ferry request was submitted to okc FSDO. Ferry permit was issued and aircraft was…Incident 20100610036119IBell 206L-3 · Port O'Conner, TXThe pilot departed Port o' connor TX. His intended destination was an oil and gas platform 50 NM offshore in the gulf of Mexico. Approximately 9 NM from his destination the pilot heard a "pop", and felt vibration. The nose of the aircraft tucked down and to…Accident 20100610035979ALuscombe 8F · Shell Knob, MOPilot departed Turkey Mountain Airport, Shell Knob, MO. After reaching an altitude of 300 feet AGL, the engine began to lose power. Pilot turned 180 degrees back to the airport. This turn resulted in a strong tail wind for his landing, overshooting the runway…Incident 20100610035799ICessna 172P · Aguadilla, PROn June 10, 2010, approximately 5:15 pm aircraft registration number N5385K was given a clearance to take off from run way 10. [privacy data omitted] (PIC)was at the controls and about 55/60 knots, he pulled back on the controls and felt that the controls…Incident 20100610035279IVonk Anton Lancair PRO · Redmond, OROn June 10, 2010 at approximately 1219 PDT, N750TV, a pressurized Lancair 4 turboprop was climbing out of 10500 MSL from bend, Oregon airport when the aircraft experienced smoke coming out from the windscreen. The purpose of the flight was to demonstrate the…