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 20090209001859IMooney M20D · Mc Kinney, TX(-23) On February 9, 2009 at approximately 1700 CST a Mooney M-20D N1923Y registered to [privacy data omitted], landed with the landing gear fully retracted at Collin county regional airport (ktki) in mckinney Texas. The flight was conducted in visual flight…Accident 20090208010639ACamron V77CAMERON · Terre Haute, INApproximately 20 minutes after lift off, the pilot light on the balloon's propane burner extinguished for unknown reasons, and multiple attempts to relight it were unsuccessful. Because the balloon was descending near power lines, the pilot pulled the rip…Accident 20090208004389ACessna 206H · Quebradillas, Puerto Rico(-23) While in route from la romana airport (mdlr) in the domican republic to san jaun international airport (sju) aircraft crashed into the atlantic ocean 200 yards off north coast of Quebradillas, p.r.. Heavy rain and winds reported in the area at the time…Accident 20090208003989ARobsin R22BETA · Encinitas, CA(-23) On the above date, [privacy data omitted] was giving [privacy data omitted] a pre-hire check flight prior to hiring him as a flight instructor for [privacy data omitted] flight school. While flying at approximately 700 feet MSL, [privacy data omitted]…Incident 20090208003639IPiper PA28RT201T · Sarasota/Brade, FLAircraft N96DR landed hard at the srq airport causing the nose gear to collapse damage to the propeller, nose cowl, and nose gear follow up doors. No one was injured in incident.Accident 20090208001829APiper PA30 · Livonia, NYOn February 8, 2009 at approximately 1030 local time, a Piper PA-30, N10JR, attempted a takeoff from the grass strip at hannas Acres airport (D75) in Livonia, new york. The aircraft was owned and operated by [privacy data omitted]. He is the holder of…Accident 20090208001499ACessna 172D · Bow, WAPilot departed kbvs to pick up passenger in orcas island. Dropped passenger off at kbli. Pilot was returning from bellingham when aircraft lost engine power. Aircraft was over water when power loss occurred. Pilot landed in an open grass field. On landing…Incident 20090208001119IStinso 1082 · Appleton, WI(-23) Pilot was making a wheel landing. Once the tail came down the aircraft started to drift to the left the pilot applied right rudder and brake but was unable to stop the aircraft prior to contact with a snow bank.Incident 20090208001049ICessna 170B · Susanville, CA(-23) While making his approach to the airport from the north, the pilot stated he recalled the Susanville airport AWOS was reporting the winds to be calm. He said he also noticed at the same time that smoke in the area was rising vertically, indicating calm…Accident 20090207025019ACessna 172N · Atmautluak, AKThe aircraft experienced an "off-field" crash landing due to a sudden gust of wind during the approach phase of the landing. The accident site was about 300 yds. Southwest of the Atmautluak Airport. Pilot stated the fuel load was 20 gals. The pilot stated he…Incident 20090207003629IAcftmg CH2000 · Andalusia/Opp, ALOn February 07, 2009, a student pilot operating N8508A, was returning from kmvc after performing a touch and go. While attempting to land at 79J Andalusia, Alabama, pilot stated as he approached runway 11, ATIS was reporting that winds were calm. Pilot…Accident 20090207003209ACessna 170B · Lake Placid, FL(-23) During an aircraft checkout (new owner), the pilot and instructor ground-looped the aircraft on the first landing causing structural damage. The pilot in command (PIC) stated that he was left of the center-line, while correcting for drift. The PIC…Incident 20090207002959IVanosd LANCAIR320 · Toms River, NJ(-23) [privacy data omitted] stated he had not aligned the aircraft with the runway properly before touchdown. Consequently, the side load on the nose gear caused it to collapse. Subsequent investigation revaled improper registration, improper markings, and…Accident 20090207002479APiper PA28160 · Terrell, TXOn February 07, 2009, a Piper, PA-28-160, N5303W, owned by [privacy data omitted] and being operated by pilot [privacy data omitted], landed short of runway 13 at Airpark East, dallas, TX., (1F7) causing substantial damage to the aircraft. There were no…Accident 20090207001899ACessna 172M · Le Roy, NYOn February 7, 2009 at approximately 1120 local time, a Cessna 172 bearing registration number N3554Q, registered to schubert brothers aviation inc. and operated by the rochester air center, sustained substantial damage while attempting a landing on runway 28…Incident 20090207001649IPiper PA46500TP · Ellwood CityCghvm flown by pilot in command, [privacy data omitted], deviated from assigned altitude of FL250 and conflicted with an E145 at FL260. The incident occurred 20 NM NE of Ellwood City VOR. Pilot stated in an interview that he was preoccupied by a malfunction…Accident 20090207001552ACessna 150K · Fairmont, NEOn February 7, 2007 at approximately 14:00 CST, a Cessna 150, N5757G and a Piper PA28-180, N55502 lost separation while on approach to runway 35 at Fairmont State Airfield located in Fairmont, Nebraska. The pilot of the Cessna was on quarter mile final at 400…Accident 20090207001541APiper PA28180 · Fairmont, NEOn February 7, 2007 at approximately 14:00 CST, a Cessna 150, N5757G and a Piper PA28-180, N55502 lost separation while on approach to runway 35 at Fairmont State Airfield located in Fairmont, Nebraska. The pilot of the Cessna was on quarter mile final at 400…Accident 20090207000919ACessna 170B · Cottonwood Fal, KSPilot aborted the takeoff on a 2600’ grass strip because the aircraft would not rotate. The aircraft went off the runway, through a barbed wire fence and flipped over. The pilot received minor injuries and the pilot/passenger was uninjured. The pilot stated…Incident 20090206003519ICessna 414 · Orlando, FLPilot stated that he felt a nose-wheel shutter during the takeoff roll, aborted the takeoff and intentionally veered to the right to exit the runway. The pilot stated that he heard a loud band prior to stopping the aircraft. Aircraft had damage to all…Accident 20090206001539ADavis Sonex · Crossville, TNPilot taxi aircraft to runway 26 ran aircraft for 15 T0 20 minuttes. Pilot departed runway 26 at Crossville airport (csv) in Tennessee engine lost power pilot made a left turn to get back to airport and attempted to land on runway 8. Pilot landed to the left…Accident 20090206001489ARobsin R22BETA · Tomball, TXAt 1045 CST, aircraft impacted the ground approximately 6 miles west of kdwh, CFI states that the student pilot was conducting a 180 degree practice auto rotation from 700 feet. After student pilot lost control around 250 feet, CFI took control of aircraft…Incident 20090206001359ICndair CL6002B19 · Wichita, KS(-23) The captain on the regional jet flight with 49 passengers, started only one engine and turned sharply out of parking in close proximity to the departure gate. The aircraft then stopped facing south into a strong wind with the nose wheel presumably…Incident 20090205004449ICessna 210E · Westhampton Be, NY(-23) Pilot states during taxi on taxiway "s" and on a heading of approximately 060 degrees his aircraft started to slide laterally to the right while on a large patch ice. The aircraft's right tire made contact with dry pavement causing the sliding to…Accident 20090205001239ASeher Bearhawk · Reno, NVOn the fifth takeoff of a newly certificated experimental-amateur built aircraft, the airplane veered left during the takeoff roll and exited runway 08 approximately 2200 feet from the departure end. Winds were reported five minutes prior to the accident as…Accident 20090205001189ABeech A36 · Santa Catalina, CAAircraft departed Catalina airport, CA (kavx) at approximately 16:39 PST enroute to john wayne, CA (ksna). Shortly after takeoff, aircraft impacted ground near Mt. Orizaba at approximately 16:42 PST. Post impact fire consumed major portion of fuselage area.…Incident 20090205000909IGulstm 680 · Grand Island, NEN599GB, CE-680, was enroute from scottsdale, AZ, to green bay, WI, at FL430, when the flight crew received a left windshield heat inop light followed by the left side cockpit window outer pane cracking. The crew diverted to Grand Island, NE. Mechanics from…Incident 20090205000789ICessna 150 · Wilsonville, ORDuring cruise pilot felt and heard explosion from engine. Pilot made immediate emergency landing in open field. No injuries or airframe damage was reported. Investigation revealed approximate 4 inch by 6 inch hole in top of engine case with lower half of #2…Accident 20090204004289APiper PA46500TP · Aspen, CO(-23) Aircraft touched down on rwy 15 at approximately A2 taxi way. When the nose wheel touched down the aircraft veered to the left then right, then left, then right again and departed the runway at approximately the 4500' mark. The aircraft pitched up on…Incident 20090204003069IAerosp ATR42300 · Madison, WI(-23) Mountain air cargo (mtna) flight 7558 reported white and green laser light illuminated aircraft while west bound @6,500 feet altitude, enroute between madision, WI (msn) and cedar rapids, IA (cid). Laser event reported by crew to atc/msn. The Dane…Incident 20090204001749IEMB ERJ170200LR · Charlotte, NC(-23) Republic airlines (R16A) flight 3215, inbound to Charlotte Douglas international (clt) @ 2000 LCL struck a deer with the left main landing gear at touchdown on runway 36-C. The landing roll out was normal as well as the turnoff and taxi to the gate. The…Incident 20090204001699IBeech 60 · Slidell, LA(-23) Pilot was landing on runway 36 and upon landing the right main landing gear and nose gear collapsed. Aircraft slid off the runway stopping 20 ft from the runway, facing south. Damage to the aircraft right wing, both props, right main gear, nose gear,…Accident 20090204001229ADoug DC3 · Mojave, CAOn February 4, 2009, about 0850 pacific standard time, a Douglas DC-3, N834TP, veered off the runway and collided with terrain during takeoff at Mojave, California. The national test pilot school was operating the airplane under the provisions of 14 code of…Incident 20090204001149IBeech B50 · Waco, TX(-23) On February 4, 2009, at approximately 1220 local time, N3581B, a Beechcraft B-50 aircraft sustained minor damage during a gear up landing at Wings for Christ airport (73F) in Waco, TX. The pilot-in-command, [privacy data omitted], airline transport…Incident 20090204001129IBeech 1900D · Manhattan, KS(-23) Great lakes 5117, operating as a 121 domestic revenue flight, departed Kansas city international airport (mci) and was enroute to Manhattan, Kansas (mhk). During the approach phase of the flight, the leading edge of the left wing impacted a bird. The…Incident 20090204001039IAntare MA32 · Torrance, CA(-23) Student pilot was on first solo in the runway 29R traffic pattern at Torrance. Student was operating an ultralight weight-shift controlled trike. When student touched down on first landing at normal speed, the trike's nose wheel began to shimmy and the…Accident 20090204000729AErcoup 415D · Whitehall, MTOn February 5, 2009, at 1609 MST, a Ercoupe 415-D, N87349, registered to [privacy data omitted]Incident 20090204000629IPiper AEROSTAR601P · Childress, TXOn February 4, 2009, N8209J, a Piper Aerostar 601P aircraft, departed plainview, Texas (pvw) enroute to Childress, Texas (cds). The pilot announced his intentions to land runway 17 at cds, then verified the landing gear was down and locked through the…Incident 20090204000449ICessna 150F · Mile Marker 90Pilot departed spanish fork airport without verifying fuel quantity in aircraft. Soon after dark after approximately 30 minutes of flight the engine quit because of fuel exhaustion. The pilot landed the aircraft on interstate hgwy 80 at mile marker 90 with no…Incident 20090203015109IRaythe G58 · Stockton, CA(-23) On February 03, 2009, while practicing takeoff and landings at Stockton Metropolitan Airport (sck), pilot in command yoichi sakurada allowed student pilot yoichi manabe to manipulate the controls for an attempted landing. During the landing attempt, PIC…Accident 20090203000689ARobsin R22BETA · Sevierville, TNOn 02/03/2009, N7687H, R22 beta was being operated part 91 in instructional use by rambo helicopters, [privacy data omitted] owner. The helicopter was occupied in the right seat by a 13 hour pre-solo student, [privacy data omitted]. The left seat was occupied…Incident 20090202025059ICessna 207A · Chefornak, AKWhile on approach to the Chefornak Airport the pilot set his flaps for 10 degrees and did not notice the normal feel of ballooning or deceleration. He continued with a wider approach to prepare for a no-flap landing. On landing the aircraft drifted to the…Incident 20090202001329IBeech N35 · Blythe, CA(-23) Pilot was accomplishing touch and go landings. He forgot to put the gear down on the last landing. Pilot stated he did not remember retracting the gear so he never thought he had to lower the landing gear.Incident 20090202000999ICessna 320D · Seaside, OROn February 2, 2009 the pilot landed at Seaside airport with landing gear retracted. The pilot admitted leaving the landing gear handle in the up position when he initiated the landing. The damage was not considered to be substantialAccident 20090202000939APiper PA24250 · Mineral Wells, TXPrivate pilot [privacy data omitted] was the pilot of a Piper comanche N5451P when it departed Mineral Wells Airport (mwl) on February 2, 2009 at approximately 18:30 CST. The landing gear failed to retract completely after take off. [privacy data omitted]…Accident 20090202000659ACessna 152 · Ellensburg, WAThe student pilot was executing his fourth solo takeoff while being supervised by his instructor [privacy data omitted]. Upon power application the aircraft started a left turn that took the aircraft off the left side of the runway. The student reduced power…Incident 20090201009029IMooney M20E · Santa Maria, CA(-23) Pilot stated it was his first flight after the annual inspection. While conducting pattern work, he performed several touch and go's with no problem, on the maneuver before final landing, while he was coming down for another touch and go with the option…Incident 20090201003589IBoeing 757231 · New York, NYDelta airlines aircraft N711ZX was being pushed back when its right winglet struck the left horizontal stabilizer of delta airlines ship N184DL, a Boeing 767, at jfk airport in New York. Investigation revealed that passengers were on board aircraft N711ZX at…Accident 20090201002719APiper PA18150 · Tallahassee, FLOn February 1, 2009 at 1500 local time, [privacy data omitted] was pilot in command with passenger [privacy data omitted] onboard of Piper PA-18-150 serial number 18090075 registration number N2424A. The aircraft departed from ayavavlla strip, a private strip…Accident 20090201002709ABbavia 7AC · Cameron, SC(-23) On February 1, 2009, at approximately 1530 local time, an Aeronca 7AC champ airplane piloted by [privacy data omitted] was cruising at altitude of 800 feet near Cameron, south carolina. [privacy data omitted] Heard and felt a rough running engine. He…