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.
Incident 20060926020649ICessna 207A · Yakutat, AK(-23) 9-27-06 Talked to the pilot [privacy data omitted] and he explained attempted take off from akwe river 1200-1400 foot beach strip, 25 miles east of Yakutat in gusty/crosswind/turbulent conditions. Aircraft ran past river bank and ended up in river about…Incident 20060926020369IBeech 1900D · Denver, CO(-23) N100UX, great lakes airlines flight 5070 was inbound from saf to den. Check airman was conducting first officer ioe. First officer was the flying pilot landing at den. During touchdown runway 34R, the aircraft landed hard on the nose gear causing minor…Incident 20060926019689IAmblmp ABCA60 · Beverly, MA(-23) Aircraft maintenance personnel had just completed 100 hour inspection on airship at Beverly Municipal Airport (bvy). During runup a gust of wind caused the main gear to strike the ground with excessive force. The impact caused the rudder control chain…Incident 20060925029069IBlanca 14192 · Spearfish, SD(-23) On September 25, 2006 at approximately 1900 local time, while landing on runway 30 at Spearfish, SD, N9840B, a Bellanca 14-19-2, the pilot lost control on landing and went off the runway. The airplane received minor damage to the landing gear. The wind…Incident 20060925028519ICessna 150F · Romeo, MI(-23) The aircraft made a forced landing in a farming field 1/4 miles south of the airport after conducting a touch and go maneuver on runway 18. After touching down on runway 18, the throttle was advanced, the aircraft began to climb and the engine then lost…Incident 20060925027409IDoug MD1010F · Oakland, CA(-23) Investigation revealed: rt main gear down on retraction after t/o. light went red and stayed red until gear handle placed down again. Crew recycled gear with same result. Acft landed @ oak without incident. Crew debrief revealed that the rt MLG gree…Incident 20060925025789ICessna 172N · Abita Springs, LA(-23) Pilot departed st tammany regional (L31) on banner towing mission over the city of new orleans. Aircraft carried 43 gallons of fuel with 40 usable. Pilot planned for flight to new orleans, two and a half hours of circling, and the return flight to st…Accident 20060925023789ABlanca 14132 · Ellijay, GA(-23) On 9/25/2006, at approximately 1830, aircraft registration N74475, piloted by [privacy data omitted] experienced engine problems and attempted to make an emergency landing. While attempting the emergency landing, the aformentioned aircraft impacted a…Incident 20060925022109IPiper PA28161 · San Diego, CA(-23) During flight instruction operations, the aircraft was subjected to a hard crosswind landing while practicing touch-and-gos. When the aircraft returned to flight, the left landing gear wheel and lower strut assembly came out of the strut cylinder and…Incident 20060925019089ICirrus SR22 · Lake Providence, LA(-23) Pilot was enroute to macon, ga when the airplane developed rough engine. The pilot asked center for the nearest airport and was directed to Lake Providence (0M8). Landing was made without damage to airplane or injuries.Incident 20060925018939IMooney M20A · Enid, OK(-23) On September 25, 2006, at 1655, N6018X, a Mooney-20-A hit the parameter fence during approach to runway 30 at Enid, OK (wdg). The flight was operated VMC. The operator indicated that both fuel gauges indicated about half full prior to departure from…Accident 20060924029949ACessna 182K · Sedona, AZ(-23) Aircraft and the pilot and one pax departed phoenix-deer valley (kdvt) for a short flight to the Sedona, AZ (ksez) airport for lunch. Aircraft never made it to ksez. Radar track shows aircraft transponder lost approx 9NM sw of the ksez airport. As of…Accident 20060924029429ACleber SPORTSMAN2+2 · Tucson, AZ(-23) Pilot stated that she accidentally bounced the aircraft and lost control while landing. The aircraft came to rest inverted with substantial damage to the wings, propeller, cowling, landing gear and fuselage.Accident 20060924028859ACessna 182Q · Cumberland, WI(-23) On 09/24/2006, at 1930Z (1430 local), N97435 a Cessna 182Q (amphibious) owned and operated by the pilot [privacy data omitted] landed with the gear down, flipped and sunk on staples lake WI on a part 91 personal flight. VFR conditions prevailed, no…Accident 20060924023369ACessna 172 · Palmer, AK(-23) Aircraft battery dead. Left magneto selected for starting. Takeoff was made on left mag only. Engine will not develop full power unless switched to both. Aircraft clipped tree tops during takeoff. Right horizontal stabilizer and left elevator dented and…Incident 20060924021319IFound FBA2C1 · Akhiok, AK(-23) Pilot statement says he lost control of aircraft during high speed taxi while repositioning the aircraft down river. Aircraft collided with a riverbank, and the floats separated from the aircraft. There were no injuries to the pilot or one passenger,…Incident 20060924020559ICessna 152 · Salem, OR(-23) Aircraft departed hillsboro enroute to klamath falls Oregon. The engine began to run rough, the pilot elected to divert to Salem. The mechanic [privacy data omitted] (Salem air center) informed me that he had discovered fouled lower spark plugs. After…Incident 20060924019699IAirbus A320231 · Philadelphia, PA(-23) N637AW was taxiing to runway 27L in phl for takeoff on flight 430 on Sunday 09/24/06 when the tower reported smoke coming from the landing gear. The aircraft returned to the gate where the technicians found the following damage: #2 MLG wheel assy inner…Incident 20060924018969IAviat A1B · Lake Jackson, TX(-23) Pilot made an emergency landing on the beach due to high engine oil temperature. In the process of landing he nosed the aircraft over bending one of the propellers. Only the pilot was on board with no injuries. The beach sand was much softer than…Accident 20060924018909ARobsin R22 · Skiatook, OK(-23) On September 24, at 1415 hours the pilot [privacy data omitted], a student rotorcraft pilot, attempted his first solo flight at Skiatook airport (2F6). The weather was clear with a 12 knot wind from about 350 degrees. The temperature was cool. The pilot…Accident 20060924018899ANorwn Apachesport · Brewster, WA(-23) The pilot [privacy data omitted] stated he was landing on runway 25 at the Brewster Anderson airport (S97). During the landing he indicated he had a right crosswind. The left wing contacted the ground and ground looped to the left. The nose gear was…Accident 20060923031079ACessna 152 · Hollywood, FL(-23) On September 23, 2006, student pilot was on his final of three take offs and landings doing his solo in a Cessna 152C. Upon touch down at North Perry Airport on runway 9 right, the student stated that the aircraft veered to the right and he tried to…Incident 20060923027429IBoeing 73776N · Oakland, CA(-23) Investigation revealed: flt crew executed go around, after bird strike during take-off. Acft landed with gross weight of 107,000 lbs. Mx inspection revealed that the bird strike had struck the f/o's pitot tube. Mx replaced the pitot tube and performed…Accident 20060923021739AAerosp SA319B · Port Alsworth, AK(-23) The pilot reported that he was transporting a previously crashed Piper PA-18 airplane on a 100 foot external load line. The external load line was attached to a spreader bar that was attached to the wing structure of the airplane. The pilot stated that…Accident 20060923020279ABeech F33A · Alabaster, AL(-23) While giving sightseeing air-rides at the wings & wheels airshow, engine lost power on takeoff due to fuel depletion. Aircraft stalled causing the aircraft to impact the ground in a slightly nose low attitude. The pilot and two passengers received fatal…Accident 20060923020009AUnivar 415C · Trenton, FL(-23) On September 23, 2006 at 10:15 local time, an Ercoupe 415-C, N3233H, registered to the pilot [privacy data omitted] collided with trees shortly after takeoff from rush airfield (no identifier) while on a flight for a biennial review of the pilot…Accident 20060923019249AAirtrc AT301 · Big Spring, TX(-23) On September 23, 2006, at approximately 0830 CDT, air tractor N23260, model 301, experienced engine stoppage while on a positioning flight from a private strip north of Big Spring, Texas, to Mcmahon-Wrinkle airport (bpg). The pilot executed an emergency…Accident 20060923018979AAmtr RV4 · Springtown, TX(-23) Pilot departed 61TE to the south and lost power shortly after takeoff. The pilot made a 180 degree turn and attempted to land to the north at 61TE. The aircraft impacted a steel pipe fence 20 feet short of the runway. Upon investigation the fuel…Incident 20060923018929IBeech V35 · Conroe, TX(-23) At approximately 12:30 pm N374T, s/n D-8165, a BE-35 landed at Conroe airport. The pilot reported on roll out his landing gear collapsed. Aircraft came to rest on the runway. Pilot only, with no injuries. Aircraft was jacked and the landing gear was…Accident 20060922031039ACessna 172S · Naples, FL(-23) Student pilot, loss of control practicing touch and goes. Initially reported as an incident. After airworthiness inspector [privacy data omitted] inspected the aircraft on October 18, 2006 incident was upgraded to accident.Incident 20060922028919IBoeing 717200 · Champaign-Urban, IL(-23) Air tran flight 895, a Boeing 717 aircraft on a flight from boston, ma to chicago, IL diverted to to Champaign, Illinois due to weather. The flight crew declared an emergency due to lack of approach plates and the aircraft landed without further…Accident 20060922026719ABeech 95B55 · North Sioux Ci, SD(-23) On 9-22-2006, the pilot [privacy data omitted] departed north platte, NE, IFR to la crosse, WI. The aircraft (Beech BE-55 N4JV) was in cruise flight at 9000' MSL with a ground speed of 190. He was in radio and radar contact with Sioux city approach…Accident 20060922022209APiper PA12 · Orient, ME(-23) On September 22, 2006, about 1330 eastern daylight time, a Piper PA-12-12, N4459M, was destroyed when it impacted the ground on halfmoon island, after takeoff from peters cove, on east grand lake in Orient, Maine. The certificated commercial pilot and…Incident 20060922022029IPiper PA28140 · Caldwell, NJ(-23) The pilot stated that he took off from runway 27 at kcdw on 08/22/2006 at approximately 1830 EDT. Approximately 50 feet above the ground the engine began to run rough. The pilot discontinued the take off and touched down again on runway 27. Brakes were…Incident 20060922021089IBoeing 777232 · Brindisi, IT(-23) Flight crew reported R1 window heater arcing with flames. Captain has reported to delta flight control the crew turned off window heat, donned oxygen masks, and they prepared to use fire extinguisher, but flames stopped just prior to its use. The fire…Accident 20060922020609AAmtr TRIQ2 · Branson, MO(-23) The aircraft was observed in level flight with engine noise present. A short time later, the aircraft banked to the right, accompanied by a lack of engine noise, and was observed to spiral/spin straight down until it was out of sight. The aircraft…Accident 20060922020359ACessna T210M · Delta, UT(-23) Pilot stated the aircraft encountered 1/2 to 1 inch of rime ice at 12,000 MSL. He requested a higher altitude and during climb to 14,000 MSL the engine coughed once and within 5 to 10 seconds it quit at approximately 13,400 MSL. Pilot established a…Incident 20060922019659IPiper PA28R200 · Chico, CA(-23) The pilot [privacy data omitted] landed at kcic with an unsafe landing gear indication. Nose gear collapsed on rollout. There were no injuries to either the pilot [privacy data omitted] or his passenger. Inspection of aircraft was accomplished at north…Accident 20060921026769AN44DX · Auburn, IN(-23) Non owner doing landings at gwb, on 10th landing lost control and departed runway where left gear collapsed and left wing came down and damaged the spar.Accident 20060921022569ADhav U6A · Kodiak, AK(-23) On September 21, 2006, at approximately 13:15 Alaska daylight time, a float equipped de havilland DHC-2 airplane, N5154G, sustained substantial damage when it impacted marshy water covered terrain about 75 miles northwest of Kodiak Alaska. The airplane…Incident 20060921019279IAirbus A320211 · Boston, MA(-23) Air Canada, flight #365, A-320-211, while awaiting pushback at gate 12 in Boston ma was struck by a unit loading device (uld) at approximately 18:10 EDT, 09/21/06. The passengers were off loaded. No injuries were reported. Damage to the aircraft was…Incident 20060921019109IGulstm 500S · Baton Rouge, LA(-23) On final approach for landing the pilot heard a transmission from an American eagle aircraft holding short for takeoff that one of his main landing gear wheels was not properly aligned for landing. Pilot executed a go around and confirmed visually that…Incident 20060920025819ICessna 310R · Scottsdale, AZ(-23) On 09/20/2006 the pilot [privacy data omitted] had his aircraft, N340TR, a Cessna 340 parked at the Scottsdale airport (sdl) at the greenway hangars. A Cessna 310, N310AR was pulled out of the hangar next to N340TR by two maintenance personnel from…Incident 20060920022059IAmtr Barracuda · Warrenton, VA(-23) The pilot of this experimental-homebuilt Barracuda, reg# N515WH lost control of the aircraft during his travel down runway 32 at Warrenton-Fauquier Airport (W66). The weather was VMC with winds reported as a right-quartering crosswind at approximately…Accident 20060920021539AAirtri Tourist · Cornwall, VT(-23) Witnesses stated that the aircraft was practicing, what appeared to be stalls, and then was seen spinning straight down. Aircraft impacted top of tree at approximately 70 feet up. Limbs were broken in a straight down path to impact point. Both occupants…Accident 20060920020979AMooney M20J · Blue Ridge, GA(-23) The pilot [privacy data omitted] accompanied by his father, on approach to private airport (57GA), landed aircraft N210SJ down wind and long down runway 18 to which upon contacting runway, failed to get the aircraft safely stopped. Tire skid marks were…Incident 20060920020859ICessna 182K · Baxley, GA(-23) Aircraft experienced hard landing on runway 26 at Baxley Municipal Airport (bhc). Nose fork assembly failed, releasing nose tire and wheel assembly from aircraft. Aircraft skidded to a stop on the paved runway. Aircraft damage is limited to: propeller…Accident 20060920020819AAmtr Onedesign · Lake Wales, FL(-23) Aircraft landed on runway 35, the tire marks on the runway indicated the aircraft touchdown was near the center line, aircraft s turned across the centerline with brakes applied numerous times. Aircraft left main tire went off the runway just fwd of…Incident 20060920020779IBell 206B · Hamilton, TX(-23) The pilot was picking up 4 heli-bags on a lanyard. One of the lanyards was about 6 feet longer than the others and the equipment dangled about an additional 6 feet lower. The pilot was unable to see the power line. The longest lanyard struck the power…Incident 20060920020659IAmtr RV8A · Mulino, OR(-23) N698BS was on takeoff roll with the canopy open, and at the point of departure the pilot attempted to close the canopy and inadvertently pushed the control stick forward causing the airplane to nose down and contact the runway hard enough to bend the…